Forum Discussion

mithunt's avatar
mithunt
Frequent Visitor
4 years ago
Solved

Help with Calculated Column

Hello All,   I am looking for some assistance in finding a calculated column which gives me results as specified in column Sales at Last date(Previous Month)    I have used this DAX and it pulls ...
  • daXtreme's avatar
    daXtreme
    4 years ago
    pms = // calc column
var LastDateOfMonth = 'Data'[Last date of month]
var CurrentProduct = 'Data'[Product]
var Result =
    MAXX(
        filter(
            'Data',
            'Data'[Date] = LastDateOfMonth
            &&
            'Data'[Product] = CurrentProduct
        ),
        'Data'[Sales]
    )
return
    Result
daXtreme's avatar
daXtreme
Solution Sage
4 years ago
pms = // calc column
var LastDateOfMonth = 'Data'[Last date of month]
var CurrentProduct = 'Data'[Product]
var Result =
    MAXX(
        filter(
            'Data',
            'Data'[Date] = LastDateOfMonth
            &&
            'Data'[Product] = CurrentProduct
        ),
        'Data'[Sales]
    )
return
    Result
mithunt's avatar
mithunt
Frequent Visitor
4 years ago

Thank you so very much it worked like a charm.. 

 

need to get some experience on writing loops then..