Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Current Period & Previous Period

Hi,

 

I'm trying to create two measures.

 

Current Period: Looks at today's date and identifies what financial period it falls into e.g Today's date would be P8 (Our calendar has April as P1)

Previous Period: essentially the same as the above but minus one period

Need Help
Show and Tell
Tips and Tricks

1 Reply

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

    Try

     

    past period = 
var _sel_p =max(selected([table]period))
Var _period = MID(_sel_p, 1, len(_sel_p)) -1
Var _prior_period = if(_period<0,12,__period)
var _prior_year = if(_period<0,max(selected([table]period))-1,max(selected([table]period)))
return
 CALCULATE(COUNT('Sales'[Sales Date]),filter(sales, year=__prior_year && period =_prior_period )

     

     

    If it does not work. If possible please share a sample pbix file after removing sensitive information.
    Thanks

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

    My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601