Forum Discussion

Bimo2023's avatar
Bimo2023
Regular Visitor
3 years ago

Column to return value from another table based on Dates

Hi  I have one table1 with non consecutive dates and values, I have created a calendar table with consecutive date and would like to add a column on calendar date to show values from Table1   I ha...
Need Help
AnastasiaS's avatar
AnastasiaS
Resolver I
3 years ago

Hello Bimo2023 

 

Could you try please the following formula?

 

output =
    CALCULATE (
        LASTNONBLANK ( Readings[Electricity usage], 1 ),
        FILTER (
            ALL (Readings ),
            Readings[Date] <= EARLIER ('Calendar'[Date] )
        )
    )

 

Regards,