Forum Discussion

kumsha1's avatar
kumsha1
Post Patron
5 years ago

Multiple column references for FILTER

Hi, VALUES can accept single column reference in FILTER... So, how can i rewrite below DAX to pass multiple column references for FILTER?, to pass another column as highlighted in RED. TIA for your ...
Need Help
niteshtrehan89's avatar
niteshtrehan89
Helper III
5 years ago

function=

var x= VALUES(SHIPPING[DISCHARGE_COMMENCE]

var y= VALUES(SHIPPING[SHIPMENT_NO])

return

SUMX(FILTER(x,y,[DATEDIFF]>=0),[TA_WEIGHTOMETER])

kumsha1's avatar
kumsha1
Post Patron
5 years ago

Hi niteshtrehan89 , thanks for your quick response.

 

I tried creating variables as mentioned but the DATEDIFF is not being accepted with error 'unexpected parameter'.