Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dax date issue

Hi,   I have my date table [Date] linked with a 1 to many relationship to with Resource Annual [Date].    The simple dax below works to calculate the first date in the series as the Production St...
DAX
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Make sure both columns in the relationship are Date type, and not DateTime.  It is not enough to change the format; it needs to be changed in the query editor.

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the response.

     

    Both of my columns are formatted as date only.

     

    The issue seems to be that once I slice by year using my date table the Resource Annual table is filtered to that year. This then become the new min date that is returned.

     

    I presume I need to make use of ALLSELECTED but can't figure out the pattern to slice by year and retain the original Production Start Year.