Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |