Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Correct YoY Measures

Hi, 

 

I am wanting to include MTD PY data for the same time period. 

 

IE:

June 2018 1st-8th is Friday - Friday...

but June 2017 1st - 8th is Thursday - Thursday

 

 

How do I do this to align with success and without the data disappearing when filtered on 2018:

 

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    What are the formulas of these measures or calculated columns? Can you share the file? The MTD won't consider the weeks. So what's the result you expect?

     

    Best Regards,

    Dale