Forum Discussion

sandraCortes's avatar
sandraCortes
Icon for Helper I rankHelper I
2 years ago
Solved

How 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...
  • ryan_mayu's avatar
    2 years ago

    sandraCortes 

    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 1
     
    pls see the attachment below