Forum Discussion
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...
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.
Yes, You can see results on the dashboard by Calculating Measure Countrows to data to calculate Carrier, It will show you, carrier count. then Select Bar chart in legend select missing date and carrier axix label. Graph and pie chart and table you can make easily