Forum Discussion
Solved
Calculate YTD for duplicate dates
Hello Experts, I am very new to PowerBI. I searched a lot to calculate YTD and came to know that we can calculate YTD only when we have distinct continous dates. But in my case I have multiple value...
srivally,
You date table doesn't contain all the possible date values of your sales table, and you don't create relationship between the two tables, thus you don't get expected YTD value.
Please check the attached PBIX file.
Regards,
Lydia
