Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

YTD vs Previous YTD

Hi all   I have the following table:     I am doing the sum of YTD and I am trying to compare it with the same period of last year (2023) but the values for PY YTD are wrong:     ...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You have not followed any of the steps which i mentioend in my previous post.  I do not see any Calendar Table at all.  Read and implement properly.

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi Ashish_Mathur 

 

Sorry about that, here is the pbix updated.

 

I created the calendar table with the columns you mentioned from my power query.

 

Still not showing the PY value and the matrix gives the error.

 

Can you please have a look? sample_sameperiod.pbix

 

Thanks.