Forum Discussion
Solved
MEASURE with condition using another table
Hello, I need to create a MEASURE which sum all the Amounts lower than a certain date (like June 30, 2023) from TABLE 1, but dates in TABLE 1 are expressed in text, therefore I need to use the TABLE...
Create a calculated column in Table 1 as:
My Date Number Format From Table 2 = RELATED ( 'Table 2'[Date] )
RELATED function (DAX) - DAX | Microsoft Learn
My Measure = CALCULATE ( SUM ( 'Table 1'[Amounts] ), 'Table 1'[My Date Number Format From Table 2] < 20230630 )
I just get this error when using the formulas above:
Ok just solved adding "Value" to the formula