I'm quite new to PowerBI and i do not understand why my formula gives me a full month last year march (todays date is 10/3)
My formula looks like this:
|- 4.363||08.03.2019 00:00|
the .pbix is the file you are using....I want to work over what you have becasue I have the same measure in a pbix I have and when I filter by months I get the right result as total ....I wondering why you can not get it....
if you dont have sensitive data send me your pbix file through this website: www.wetransfer.com (very easy to use...self explanatory)
to this email- firstname.lastname@example.org
I have send you an excel with some powerpivot and pivot data. I have just made an example - its not the real data, but i still have the problem. It does not give me YTD, but YT full month.
2019 goes from 1st jan 2019 to 9th March 2019
Same period last year should be:
1st jan 2018 to 9th of march 2018
Hope you can help.