Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
7 years ago
Solved

Matrix: Common variance column

Hello,   I'm looking for a way to create a table like below, Name Customer ID Sales No Product Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Variance A C1 S1 X 1091...
  • v-chuncz-msft's avatar
    7 years ago

    SivaMani,

     

    You may try the measure below.

    Measure =
    IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )