Forum Discussion
amandabus21
3 years agoHelper V
YTD Calculation
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 ...
Anonymous
3 years agoNot applicable
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
amandabus21
3 years agoHelper V
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.