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 am starting to learn Power BI and i am stuck while doing YTD calculation.
I linked 2 tables. Table 1: Customer name, Ordered Date, Revenue
Table 2: Created a DIM Table
Solved! Go to Solution.
Hey,
this seems odd ...
Here you will find a sample pbix file
The Revenue YTD measure looks like yours:
Revenue YTD = TOTALYTD(SUM('Fact'[Revenue]),'Calendar'[Date])
Please check your relationships, the relationships look like this:
And my sample data looks like this:
Hopefully this proivides you with the necessary hint.
Regards,
Tom
Hey,
please provide the exact formula of your YTD calculation.
Besides that, maybe you want to have a look at this site: https://www.daxpatterns.com/time-patterns/
Regards,
Tom
Hi Tom,
Thanks for the fast reply.
Hey,
this seems odd ...
Here you will find a sample pbix file
The Revenue YTD measure looks like yours:
Revenue YTD = TOTALYTD(SUM('Fact'[Revenue]),'Calendar'[Date])
Please check your relationships, the relationships look like this:
And my sample data looks like this:
Hopefully this proivides you with the necessary hint.
Regards,
Tom
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |