YTD Flag Problem

[Anonymous]

Dear community,

I have the sales order data from Jan 2020 until Feb 2022. I have a separate Calendar table which serves the purpose of Monthnum, weeknum, monthoffset and many more. It has YTD_Flag Measure as well. When I am using the the YTD_Flag to show the number of sales order per month for each year. It is showing me the Jan and Feb data for both 2020 and 2022, but for 2021 it is showing me the values for March as well and that too be incorrect (Mar 2021 has total values as 1564, but YTD shows it as 114). I just wanted to see the data until Feb 2021 (not Mar 2021) because I need to compare the data for 2020 & 2022(for which I do not have the data for Mar).

Could you please help, what is the issue here?

Many thanks in advance.

[MFelix]

Hi @Anonymous ,

I believe that your issue is related with the calculation of the week because can be picking up one or more days from march.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.