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 any of the month is missing we need to show that month on X-axis and value should be 0 its fine to show. How can we achieve to this requirement through DAX.
Below is the screenshot for referenec.
Note: The above image we can see inbetween May and July months June is missing so I need to show the Jun month on X-axis and value should be 0 like that (if missing months are one or more need to show that months name and value sholud be 0) need your help on this DAX.
Can someone please help me with the above scenarion. I really thankfull to them.
1 Reply
- Syk
Resident Rockstar
You 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
