Forum Discussion

Anonymous

Not applicable

7 years ago

SamePeriodLastYear error

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 idea...

Tutorial Requests

Zubair_Muhammad

Community Champion

7 years ago

Anonymous

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

Anonymous

Not applicable

7 years ago

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

v-piga-msft
Resident Rockstar
7 years ago
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
Anonymous
Not applicable
7 years ago
v-piga-msft
I try to use the formula like below but no content:
- v-piga-msft
  Resident Rockstar
  7 years ago
  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
  Resident Rockstar
  7 years ago
  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