Forum Discussion
Missing months dax expression with null values
Hi All, I need your help for one of my requirement I have columns like year and month I need to show data with respective to the months and years data on X-axis. The scenari is In particular year...
Syk
Resident Rockstar
Resident RockstarYou need to create a date table. Your source data is missing those dates and creating a date table will fill in all the gaps (and give you other functionality down the road). Check out this link:
https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query