Forum Discussion

PhoTaiGuy's avatar
PhoTaiGuy
Frequent Visitor
3 years ago
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 ...
Need Help
  • PhoTaiGuy's avatar
    PhoTaiGuy
    3 years ago

    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. 

HughLa's avatar
HughLa
Resolver IV
3 years ago

Can you share your .pbx file with sample data here?

PhoTaiGuy's avatar
PhoTaiGuy
Frequent Visitor
3 years ago

I didn't see an option to attach the files so I uploaded to a One Drive folder:

 

Removed Link

 

I have the slicer to show October and November sales. The Bowls in this case would be expected to be (0 - 10 = -10) instead of (blank - 10 = +10).

 

I think because November Bowl sales is blank, the measure can only look at October and then HASONEVALUE comes up as true so no subtraction takes place?