Forum Discussion

janislv's avatar
janislv
Helper I
5 years ago

Virtual relationship, datatable as variable

Is there any solution for creating a virtual relationship with the calendar table for a measure that contains datatable as variable?   var table_x = DATATABLE("Date",DATETIME,"Value",DOUBLE,{{"01/...
DAX Calculation
amitchandak's avatar
amitchandak
Super User
5 years ago

janislv , Not very clear Treatas should work

 

or

 

CALCULATE(sumx(filter(table_x,table_x[Date] in VALUES('Calendar'[Date]),[Value])