Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |