Forum Discussion
Same column calculation with condition in another column
Anonymous , Create a date column
date = eomonth(date([year], [month], 1),0)
then create a new column
last month Cost =
var _last = eomonth([Date],-1)
return
[cost] - maxx(filter(Table, [Product] = earlier([Product]) && eomonth([Date],0) = _last) , [Cost])
Super UserAnonymous , Create a date column
date = eomonth(date([year], [month], 1),0)
then create a new column
last month Cost =
var _last = eomonth([Date],-1)
return
[cost] - maxx(filter(Table, [Product] = earlier([Product]) && eomonth([Date],0) = _last) , [Cost])
Hi amitchandak
I have another question relating the original one. I would like to know how to calculate the quartely difference per Product like below. The 1st quarter is from April to Jun, and the 2nd quarter starts from Jul. I am looking for a solution to calculate the difference of quartely aggregated cost per product. I would appreciate if you provide a sample DAX code. Thanks.
Year Month Product Cost Cost difference from last quarter (Required result) 2022 4 A 10 0 2022 4 B 20 0 2022 5 A 10 0 2022 5 B 20 0 2022 6 A 10 0 2022 6 B 20 0 2022 7 A 15 15 2022 7 B 25 -10 20222 8 A 15 15 2022 8 B 25 -10 2022 9 A 15 15