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.
Hello,
I am getting wrong values using the SAMEPERIODLASTYEAR measure.
Solved! Go to Solution.
I am getting wrong values using the SAMEPERIODLASTYEAR measure.
= CALCULATE ([New Hire],FILTER ( ALL ( 'FY Calendar'[Date] ), 'FY Calendar'[Date] <= MAX ( 'FY Calendar'[Date] ) ), SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ))What I am trying to get is the total headcount in the previous year. Any help will be greatly appreciated.
So what's wrong with the result of the measure? To be general, you may modify your measure like pattern below and check if it can meet your requirement:
Measure = CALCULATE ( [New Hire], SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am getting wrong values using the SAMEPERIODLASTYEAR measure.
= CALCULATE ([New Hire],FILTER ( ALL ( 'FY Calendar'[Date] ), 'FY Calendar'[Date] <= MAX ( 'FY Calendar'[Date] ) ), SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ))What I am trying to get is the total headcount in the previous year. Any help will be greatly appreciated.
So what's wrong with the result of the measure? To be general, you may modify your measure like pattern below and check if it can meet your requirement:
Measure = CALCULATE ( [New Hire], SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
User | Count |
---|---|
85 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |