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

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.

  • jayesh25parab's avatar
    jayesh25parab
    Frequent Visitor
    7 years ago

    hi I am doing the right relationship and all the dates are popping in the datedim but when I create a table with both the relationship dates I get null in datedim column can you plz help me?

     

    • jayesh25parab's avatar
      jayesh25parab
      Frequent Visitor
      7 years ago

      Anonymous

      The datedim is a table created using DimDate = CALENDAR("1/1/2008","12/31/2020") and submit date is a another column in other table with duplicate dates. The relationship is both ways between the two column in spite of it when I try creating a table between the 2 columns I get null values for dimdate column