SamePeriodLastYear error

[Anonymous]

Hi All,

I am doing a headcount report and would like to use the SamePeriodLastYear function to calculate last year headcount, however, the results are wrong and the numbers look strange. Any ideas?

[Zubair_Muhammad]

@Anonymous

In the Table Visual, are you using the Month column from Calendar table?

[Anonymous]

i am using the "Month" in Calender table as the row content.

[Anonymous]

@v-piga-msft

I try to use the formula like below but no content:

[v-piga-msft]

Hi @Anonymous,

Have you solved your problem?

If you have solved, could you please share your solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous,

If it is convenient, could you share your data model so that I can test with your scenario.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous,

What about use the formula below?

py =
CALCULATE (
    SUM ( 'Table1'[Headcount] ),
    FILTER ( 'Table', YEAR ( 'Table'[Date] ) = YEAR ( MAX ( 'Table'[Date] ) ) - 1 )
)

Here is the output.

 

 If you still want to use Time Intelligence functions for your case, please share some data sample and the relationship between the tables.

Best  Regards,

Cherry