cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srivally Regular Visitor
Regular Visitor

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

Highlighted
Moderator v-yuezhe-msft
Moderator

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.
srivally Regular Visitor
Regular Visitor

Re: Calculate YTD for duplicate dates

@v-yuezhe-msft

Thank you. I was missed it.

jayesh25parab Frequent Visitor
Frequent Visitor

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?

 

jayesh25parab Frequent Visitor
Frequent Visitor

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