Forum Discussion
Solved
Creating a Measure based on another Measure and spread across a Time Frame
Hi...I'm even struggling to formulate the question to be honest. I have a Measure that counts rows depending on the content of a specific cell e.g. Overdue, On Target, Not Required etc. No probl...
Otto_Luvpuppy , can you create an incremental period then you can get last period like
This Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=max('Date'[Period Rank])))
Last Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=max('Date'[Period Rank])-1))
Refer the way it is done in Week
Thanks...I will give that a try.