Forum Discussion
DAX lookupvalue with date condition
Hello, I want to lookupvalue based on a particular date. There are 2 tables. Table 1 with meter_id, power outage column and measurement date. Table 2 with child meters associated with the meter_id f...
123abc
Community Champion
Community ChampionThe DAX formula I provided should be used as a calculated column in Table 2, not as a measure.
You should add this formula as a new calculated column in Table 2 to calculate the "child power outage" values based on the conditions mentioned in your original question. Calculated columns are used to create new columns within your table, while measures are used for aggregations and calculations at a summary level.
I tried this DAX formula as calculated column but it does not work for me. It shows only blanks.