Forum Discussion
Creating a Month Over Month Column with Blank Data Present
Got this to work by creating a new table and creating a 1 to many relationship using:
Table = DISTINCT( 'Sheet1'[Period])And then my matrix and my Month over Month measure referenced this new 'Period' table/column.
Hi PhoTaiGuy
If I understand your question correctly, you want to show all of the months in your table?
On your columns you can select Show items with no data. Or in your your measure you can add +0 to your calculation.
Regards
Hugh
Thank you for reviewing Hughla.
"Show items with no data" doesn't create a visible change.
I've tried adding the +0 to the measure, or even a random number, and it doesn't go through as a number that can be used later. If I put +25 to the measure it still shows up as 0 and my difference formula won't take that into account.
Maybe the issue is that the raw data doesn't have anything for Plates in September 2022 (in my original example) so I can't force a value to that missing data point?
Hi PhoTaiGuy
Ok, I misunderstood your question.
Create a measure that returns the value of your column +0, so something like this:
Sales = SUM('Sheet1'[Sales]) +0Then use that as your value in your table. That should return 0 if there is no values.
Let me know if that works.
Hugh
Thanks again HughLa
Injecting the +0 didn't work for me. Tried to take it a step further and played with adding +0 in various parts of the measure and that didn't work either.
Playing around with the table and only using HASONEVALUE, the table won't even return a True or False. Just a blank.
Item June 2022 Sep 2022 Change Mugs True True False Plates True blank True Bowls blank True True