I have a dataset for a Date Dim (Integer date, full date datetype & all possible hierarcies ). I do a join to another datecolumn in a transtional dataset . Both are of datatype date same format (mm/dd/yyyyy). Join is not honoring its falling out. The other option i have is do a integer join, my datedim have datekey which is an integer and i need to convert my datecolumn in transtional data to a integer of format yyyymmdd.
First why is my date join not honoring the join and if powerbi doesn't support it . How can i convert my date to integer to make use of integer join
I was able to get the date converted to integer using format and value function and then joined back to integer date in my date dim. But is date join not support in powerBI?
Date joins are supported - even preferred over SK joins. What do you meant "not honouring". Are you saying the join won't even complete, or it completes but then the behaviour is unpredictable? Is there any time key information in one of the columns? Is it possible you have rouge records in one of your date columns that are not dates? Are both date columns from the same locale?
* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
i have two datetime columns. i want to join on just Date. i covert each column from DatetTime do just date. i go to join on date, and the model does NOT parse - it cannot find a record match. i the background, SSAS is STILL storing the datetime info, even though i changed the datetime data type to date. so it does not drop the time info on the data point.
SO the model does not parse - so you have to make another tpye of key....