Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

broken relation with date dax table

Hello,   I have a dax table as follow Date = CALENDAR(DATE(2018,1,1),DATE(2030,12,31))   And a fact table with sales and report repiod (multiple with same time/date).   I made a link one to ma...
Date
  • MattAllington's avatar
    MattAllington
    5 years ago

    You really need to post an image of your model. You should not need USERELATIONSHIP. It is not clear if [report period] is a date. You should not be using the fact column inside SAMEPERIODLASTYEAR

  • Anonymous's avatar
    Anonymous
    5 years ago

    I finaly added a segment with the Report[Report Period] and it works MattAllington  !

    I wonder how ? Did it regroupe the report ?

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
5 years ago

Split the date/time column in the fact table into 2 columns, one for date, one for time. Then join on date