Create another dataset which is just a column with the dates e.g. January 2019 - December 2021. Where each row is a day.
Then just bring that data in, and do a count on the number of days based on your parameter matching the month in your new dataset.
Please see attached example.
Number of Days in Month.twbx 18.5 KB
I am not able to open the attachment.
Could you please send me updated one.
1 of 1 people found this helpful
To Calculate the number of months for a particular month
use this calculated field
DATEPART('day', DATEADD('day', -1, DATEADD('month', 1, DATETRUNC('month', [Date]))))
Here date would be your field of date which you wanted to use.
I hope this would be helpful