Forum Discussion

Anonymous's avatar
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...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-piga-msft

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

 

  • v-piga-msft's avatar
    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's avatar
    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