Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
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:
382.822 | 01.03.2019 00:00 |
394.818 | 02.03.2019 00:00 |
367.519 | 05.03.2019 00:00 |
357.034 | 06.03.2019 00:00 |
310.275 | 07.03.2019 00:00 |
- 4.363 | 08.03.2019 00:00 |
464.177 | 09.03.2019 00:00 |
5.750 | 10.03.2019 00:00 |
7.328.280 |
Hi @Anonymous
Can you share a pbix sample?
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- dominguezcampusano@gmail.com
🙂
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |