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

 

So when I create a new relationship between the date and the callender, all charts get messed up (Hierachy disapper and I get error with the date filter) i.e. FROM:

 

 

TO:

 

Kindly advise with that matter.

Thanks

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

10 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi salafoo ,

     

    What erro you are getting? If you click on SEE DETAILS on the error.

     

    Thanks,

    Pragati

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi salafoo ,

         

        Did this visual had anything in the Filter pane? Check the filter pane against this visual. Looks like there is column on this visual used as a filter which doesn't exist anymore.

         

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

         

        Thanks,

        Pragati

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    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