Forum Discussion
LY YTD Calculation
Hi, I need assistance with creating a DAX formula for LY YTD values. FYI - I have a period slicer in my model (2 slicers, YEAR and QUARTER). The problem is, the values in my model have...
hi amitchandak & Greg_Deckler ,
Thank you both for your prompt replies.
Both solutions can calculate YTD, however cannot calculate YTD filtering "actuals" only.
I can workout YTD, but the key component is for the period criteria to be dependent on figures being present in "actuals" beyond a certain date.
Cheers,
Dan
Greg_Deckler
Community Champion
Community ChampionAnonymous - Going to need to get some sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490