Forum Discussion

Otto_Luvpuppy's avatar
Otto_Luvpuppy
Icon for Helper II rankHelper II
6 years ago
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...
Need Help
Show and Tell
  • speedramps's avatar
    speedramps
    6 years ago

    Download this example 

     

    Example 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123