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.
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]) +0
Then 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