Forum Discussion
sandraCortes
Helper I
2 years agoHow to include rows with date null using a date range slicer
Hello Everyone, I have an issue that I don't know how to handle, someone can help me? In a report we have a slicer for a date range and a table that retrieves data according to that filter and othe...
- 2 years ago
try to delete the relationship between two tables and create a measure
Measure = if(ISBLANK(max('Table'[date])),1,if(max('Table'[date])<min('Table 2'[date])||max('Table'[date])>max('Table 2'[date]),0,1))add the measure to the visual filter and set the value to 1pls see the attachment below
ryan_mayu
Super User
2 years agotry to delete the relationship between two tables and create a measure
Measure = if(ISBLANK(max('Table'[date])),1,if(max('Table'[date])<min('Table 2'[date])||max('Table'[date])>max('Table 2'[date]),0,1))
add the measure to the visual filter and set the value to 1
pls see the attachment below