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/01/2021",354.6}})
return
CALCULATE(sumx(table_x,[Value]),TREATAS(VALUES('Calendar'[Date]),???
DAX Calculation

1 Reply

  • 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])