Forum Discussion
Joining Date Dimension with Calculated Value
I am having issues with a join on the date dimension with one of the calculated value .
Here is my use case.
I have two transaction table and one date dimenion table in my model
I have to pick the dates in this order
Table A.Date 1
Table A.Date 2
Table B.Date 3
Table B.Date 4
Step 1
In Table A ,
I created a calculated Value "Date1TabA" as
DateXTabA = COALESCE('Table A'[Date 1], 'Table A'[Date 2])
Step 2
In Table B ,
I created a calculated Value "Date1TabARelated" as
Date1TabARelated = RELATED('Table A'[DateXTabA])
DateYTabB = COALESCE('Table B'[Date 3], 'Table A'[Date 4])
DateStart = COALESCE('Table B'[DateXTabA], 'Table B'[DateYTabB])
Step 3
I have a one to many relationship with Date Dimension and Table B on
DateUS = DateStart
I getting blank in FY column from Date Dimension , whenever there is a blank in Table A.Date 1 , even though DateStart has value.
Thanks in Advance.
1 Reply
- lbendlin
Super User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523