Forum Discussion

salafoo's avatar
salafoo
Helper I
6 years ago
Solved

Issue with Dates relationship

Hello Freinds,   I have an issue with creating relationships between Date (Calander) and other dates in the datasets (calculated by DAX).   A) Date Table:   2) Calculated Date by DAX ...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Because you have used [Create On].[Date] in your calculated column formula, and when you created relationship, the original date hierachy was broken and the formula caused error.

    So you can try to change the connection direction to let Calender table date hierachy disappear by dragging Calender table [Date] column to original table [Create On] column, just like this:

    Or you can directly remove the .[Date] in your formula:

    LASTDATE('ES Business Development Applications ST'[Create On])

    Hope this helps.

     

    Best Regards,

    Giotto

Pragati11's avatar
Pragati11
Super User
6 years ago

HI salafoo ,

 

Your date format for the DATE column which is used to create relationship, is same in both the tables right? 

Can you screesnhot your data model here please or .pbix file?

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

salafoo's avatar
salafoo
Helper I
6 years ago

Both formatted as date!

 

 

 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi salafoo ,

     

    That's tough to answer this way. Can you screenshot your data model ans how relationships are done?

    It will be best if you can share the .pbix file.

     

    Thanks,

    Pragati