Forum Discussion
Missing data points for moving months
We are trying to calculate 12 moving months sum of a metric. The bar chart below has all the values from Apr 2019 to May 2020, however complete data points for May 2020 is missing. We dont have any...
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Are you using date table? In this you should use date table and month year should come from date table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
We have posted the sample data for your reference. Please let us know.