Forum Discussion

ankush-vem's avatar
ankush-vem
Frequent Visitor
4 years ago
Solved

DAX Calculation

Hi Team,  I need your help in writing a dax formula to get the result from table on the right hand side.    The Current table has a list of columns such as Date, No. of Shares, Close Price and Amo...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ankush-vem , Try a measure like

     

    measure =
    var _max = maxx(allselected('Date') ,[Date])
    var _price = calculate(Max(Table[price]), filter(allselected(Table), Table[Date] = _max))
    return
    sumx(Table, Table[No of shares] * _price )

amitchandak's avatar
amitchandak
Super User
4 years ago

ankush-vem , Try a measure like

 

measure =
var _max = maxx(allselected('Date') ,[Date])
var _price = calculate(Max(Table[price]), filter(allselected(Table), Table[Date] = _max))
return
sumx(Table, Table[No of shares] * _price )

uthpalakinivita's avatar
uthpalakinivita
New Member
4 years ago

Hi Amitchandak,
Thank you for your reply and it retuns a value but no way of seeing its correct or wrong. Can we split this messure into two? one for the selected date's close price and then we can multiply it by the no of shares?

Also can you advise on how we can filter the ledger records on and before the selected date.
Thank you,
Uthpala