Forum Discussion
Solved
DATEADD (PREVIOUS MONTH) + SUMMARIZE
Dear all. I have an issue with a DAX formula (I work with Power Pivot, not with Power BI). Problem ussing at the same time DATEADD + SUMMARIZE. To be easier, I created a simple example with date...
LEJ , Try add columns on top summzrize for such columns
example
measure =
Var _tab =
Addcolumns(SUMMARIZE(Table, Table[Product], Table[Month]) , "_1",[This Month], "_2", [Last Month] , "_3", [Last month Qty])
Return
Sumx(_tab, ([_1] -[_2])*[_3])
amitchandak
Super User
Super UserLEJ , Try add columns on top summzrize for such columns
example
measure =
Var _tab =
Addcolumns(SUMMARIZE(Table, Table[Product], Table[Month]) , "_1",[This Month], "_2", [Last Month] , "_3", [Last month Qty])
Return
Sumx(_tab, ([_1] -[_2])*[_3])
