Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts,
I wonder if it is possble to write a measure, to display date information that the day have no data, as shown
This is the desired output
Many thanks!
Simon
Solved! Go to Solution.
Hi @Anonymous
You may create 3 measures to get the date value.Then drag them to visual level filter.Attached sample for your reference.
Date of A without Data = IF(ISBLANK(SUM(Table1[A])),1)
Regards,
Cherie
Hi @Anonymous
You may create 3 measures to get the date value.Then drag them to visual level filter.Attached sample for your reference.
Date of A without Data = IF(ISBLANK(SUM(Table1[A])),1)
Regards,
Cherie
Hi Cherie
Many thanks for your help!
Simon
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |