Forum Discussion

srivally's avatar
srivally
Helper I
8 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

srivally's avatar
srivally
Helper I
8 years ago

Anonymous
I have created the relationship, but I'm getting YTD as blank values. I have attached the same here
https://www.dropbox.com/h

Anonymous's avatar
Anonymous
Not applicable
8 years ago

srivally，

Please check your Date table and create a visual as shown in the YTD-MOD PBIX file. By the way, I am unable to access your PBIX file.

Regards,
Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      srivally，

      Have you checked the YTD-MOD pbix file I shared? As my previous post, your date table doesn't contain all the possible date values of your sales table. Please change your Date table to the following:




      Regards,
      Lydia

      • srivally's avatar
        srivally
        Helper I
        8 years ago

        Anonymous

        Thank you. I was missed it.