Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a table which has some records with null in the DATE field. Now my filter in the report is based out of that DATE field. When i try to run the report with that date, it excludes records which doesn't have a date value but i need those records as well in my output
How to handle this?
Appreciate your help.
Thanks
Russell
Solved! Go to Solution.
You can create a new table will all dates and use that in your output. Check out this article for a more detailed guide: https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
You can create a new table will all dates and use that in your output. Check out this article for a more detailed guide: https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |