Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a field in my database with dates, some have missing values.
I want to create a simple chart that shows which dates have missing values. What is the best way to represent this please?
Also, to follow on - I have another date which I have calculated the difference - i.e. date2-date1, how can I present the difference in days in a chart with the missing dates? Just need a few pointers please.
Regards,
S
Hi @SachinC,
Have you tried the solution provided above? Does it work in your scenario? If you still have any question, feel free to post it here.
Regards
Hi @SachinC
If you have a date table that has all dates, and you have a relationship between your date table and your data table, one option is to add a column to your date table that counts the number of missing days from your child table. This worked for me, but you'll need to substitute your own table name in.
If this helps then we can solve your other issue.
Missing Dates = IF( CALCULATE( COUNTROWS('Table1') )>0, --- THEN --- 0, --- ELSE --- 1 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |