Forum Discussion
DJOXXXA
Helper I
Helper ICalculate YTD value with Week slicer
Hi all, I have a small question regarding YTD and MTD calculation with filters for weeks in Power BI: I want to create a card which will show this years YTD vs last years YTD as a percentage, b...
Hi all,
Turns out, I was using the correct formulas, but my Date column in my Calendar was not Marked as Date Table, and that was causing this issue.
Mariusz
Community Champion
Community ChampionHi DJOXXXA
Try this.
Sales Year To Date =
CALCULATE(
[Sales],
DATESYTD( 'Calendar'[Date] )
)
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
DJOXXXAHelper I
Helper IDear Mariusz,
Thank you for your reply! I have this formula set up already, but it is not working properly. As you can see, first picture represents the table without any slicers:
And this picture represents the same table with slicer for week: (as you can see, PBI recalculates YTD measure from the first date in the selected week, not from the January 1st)
- DJOXXXA
Hi all,
Turns out, I was using the correct formulas, but my Date column in my Calendar was not Marked as Date Table, and that was causing this issue.