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.
Hello,
Im having some toruble getting a YTD Calculation.
This is what I am trying to recreate.
When I recreate in Power BI using Year-to-Date quick measure, it is not giving me the same numbers:
Hi,
Power BI asked you to create a Date Table. Without this you can not use the YTD functions
So create a date table, declare it as date and link it with your table and it will work.
Hope it helps
Hi @Anonymous ,
I do believe i have date table named "merged FC".
I think what is happening in my year to date is that it is adding every month until the end of the year. But what I need is all the sum from that month last year to the month next year.
For example sum of all ridership from August 2022 -August 2023.
Not July + August.
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 |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |