Forum Discussion

AdamMetz23's avatar
AdamMetz23
Advocate I
1 year ago
Solved

Date Slicer Filter Issue

Dear Community,   May I ask for help as I run into the following issue. I have created a date table by using the following DAX formula:   The DIM Date Table is connected to the Fact Tabl...
Need Help
Tips and Tricks
  • danextian's avatar
    danextian
    1 year ago

    Hi AdamMetz23 

    Try created a calculated column using  isblank(RELATED(datetable[date])) in Azure works table to check if they return non-blank values.

danextian's avatar
danextian
Super User
1 year ago

Hi AdamMetz23 

Try created a calculated column using  isblank(RELATED(datetable[date])) in Azure works table to check if they return non-blank values.

  • AdamMetz23's avatar
    AdamMetz23
    Advocate I
    1 year ago

    Hi danextian ,

    Thank you for showing the formula, the suggested confirms that it it returns blank as I have showed in the visualization. 

     

    Do you might know how it can be fixed?

    Thank you,

    Adam

     

    • danextian's avatar
      danextian
      Super User
      1 year ago

      This is weird. I can see that they're both dates. Can you please do a isblank( LOOKUPVALUE(DatesTable[Date], DatesTable[Date], Azure[CreatedDate]) ) to check if this is still the case?  Also check if the min date in Azure is the same min date in DatesTable.

  • AdamMetz23's avatar
    AdamMetz23
    Advocate I
    1 year ago

    Thank you for having looked into it.

     

    It turns out the issue was that in Power Query the Azure table date column type was date/time. Once I changed it to Date. It solved the problem with DAX and filtering.

     

    Thank you.

    • danextian's avatar
      danextian
      Super User
      1 year ago

      I was going to tell you to look into this datat but your screenshot showed that both columns were dates.