Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Month over Month

Hello All,   I have a very flat table Product -------- Month A ---------------- JAN B ---------------- JAN B ---------------- FEB D ---------------- JAN A ---------------- JAN A ------------...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Anonymous

     

    You could try this calculated table

     

    Table 2 = 
VAR T1 = ADDCOLUMNS('Table',"MonthAsDateTime", DATEVALUE('Table'[Month] & "-2018"))
VAR LeftTable = SELECTCOLUMNS(T1,"Product",[Product],"MonthAsDateTime",[MonthAsDateTime])
VAR RightTable = SELECTCOLUMNS(T1,"Product",[Product],"MonthAsDateTime",EDATE([MonthAsDateTime],-1))
VAR Exceptions = EXCEPT(LeftTable,RightTable)
RETURN GROUPBY(Exceptions,[Product],[MonthAsDateTime],"C", SUMX(CURRENTGROUP(),1))

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Anonymous

 

You could try this calculated table

 

Table 2 = 
VAR T1 = ADDCOLUMNS('Table',"MonthAsDateTime", DATEVALUE('Table'[Month] & "-2018"))
VAR LeftTable = SELECTCOLUMNS(T1,"Product",[Product],"MonthAsDateTime",[MonthAsDateTime])
VAR RightTable = SELECTCOLUMNS(T1,"Product",[Product],"MonthAsDateTime",EDATE([MonthAsDateTime],-1))
VAR Exceptions = EXCEPT(LeftTable,RightTable)
RETURN GROUPBY(Exceptions,[Product],[MonthAsDateTime],"C", SUMX(CURRENTGROUP(),1))

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Awsome you are the man!