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.
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.