Reply
Regular Visitor
Posts: 17
Registered: ‎07-19-2018

Re: Calculate YTD for duplicate dates

@v-yuezhe-msft
I have checked the Date table and Sales table as well. I'm not sure where I'm missing. Can you please help me on this.
https://www.dropbox.com/s/nrjusedc2na7kz4/YTD.pbix?dl=0

Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: Calculate YTD for duplicate dates

@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:
0.PNG



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 17
Registered: ‎07-19-2018

Re: Calculate YTD for duplicate dates

@v-yuezhe-msft

Thank you. I was missed it.

Frequent Visitor
Posts: 3
Registered: ‎10-15-2018

Re: Calculate YTD for duplicate dates

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?

 

Highlighted
Frequent Visitor
Posts: 3
Registered: ‎10-15-2018

Re: Calculate YTD for duplicate dates

@v-yuezhe-msft

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