Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |