Forum Discussion

jacko11's avatar
jacko11
Frequent Visitor
4 years ago
Solved

Combining two columns after the latest value

Hello,   I have two columns and I want to combine these two columns after the latest value. Could you please help me?   Example:   Date  Column A Column B Combined Column A and B 2022-...
Need Help
  • moizsherwani's avatar
    moizsherwani
    4 years ago

    This calculates the max date of column B and then uses it till it gets to the date and then to A. Snippet and sample file is also attached.

    A+B =
VAR MaxDateB =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Table', NOT ( ISBLANK ( 'Table'[B] ) ) )
    )
RETURN
    IF ( 'Table'[Date] <= MaxDateB, 'Table'[B], 'Table'[A] )

     

     

moizsherwani's avatar
moizsherwani
Icon for Continued Contributor rankContinued Contributor
4 years ago

Hi jacko11 

 

It isn't clear what you mean by combine the two column after the latest value? From the snippet example it seems like you are taking Column B as a priority and then when there is nothing in column B then you take column A, is this correct?

 

If that is the case you would simple do something like 

 

Combined Column A and B = If(NOT(ISBLANK(Column B)),Column B, Column A)