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
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
1 year agoSuper User
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.