Forum Discussion
Solved
Creating a Month Over Month Column with Blank Data Present
Hello everyone, I'm a bit lost on the right approach to achieve this. I'm attempting to create a Table or Matrix with a column showing the change in value from a user selectable month to another ...
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
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 |