I am looking to create a dynamic Sum If measure but cannot get it right. I saw this topic, remove link because would not let me post , but still am having trouble.
Since we are currently in Fiscal Period 4, I only want to sum periods 1-3 to get 60. Here is what I have but I don't want a hardcode of "4" in there:
Go to Solution.
Hi @USABB_Data ,
You can try to create measure like DAX below.
MF YTM = CALCULATE(SUM(Table1[Sales]),FILTER(ALLSELECTED(Table1),Table1[SLS_ID]=MAX(Table1[SLS_ID])&&Table1[Fiscal Period]<MAX(Table1[Fiscal Period])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Incredible, it worked perfectly!! Thanks!!
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.