Forum Discussion

HolgerS's avatar
HolgerS
Frequent Visitor
7 years ago
Solved

Relationship between dimension and data table based on date column

Hello,   I have problems to build a relationship between a dimension table and a data tabel based on Date. The dimension table contains a column in the Date-format, the data table in the DateTime-f...
Need Help
  • amitchandak's avatar
    amitchandak
    7 years ago

    create a new date column using the format function.  And join the dimension using that.

     

    Column = FORMAT(Table[date],"MM-DD-YYYY")

     

     

HolgerS's avatar
HolgerS
Frequent Visitor
7 years ago

Thanks, I will try both solutions.

Holger