Forum Discussion
AdamMetz23
1 year agoAdvocate I
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...
- 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
1 year agoAdvocate I
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
1 year agoSuper User
I was going to tell you to look into this datat but your screenshot showed that both columns were dates.