Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

show dates with no data

hello i have a table called carriers and a date table with all days of calender. i want to find which carrier has no data o na specific date to show in a table in dashboard. here;s an example: ima...
DAX
Help Request
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Date Table:

    Date = CALENDAR(MIN('Table'[date]),MAX('Table'[date]))

         

    Measure:

    Missing = IF(SELECTEDVALUE('Date'[Date])<>SELECTEDVALUE('Table'[date]),1,0)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

You can try the following methods.

Date Table:

Date = CALENDAR(MIN('Table'[date]),MAX('Table'[date]))

     

Measure:

Missing = IF(SELECTEDVALUE('Date'[Date])<>SELECTEDVALUE('Table'[date]),1,0)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.