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

     

     

jacko11's avatar
jacko11
Frequent Visitor
4 years ago

Hi moizsherwani,

 

Thank you for your answer.

 

I meant till to the last value on column B, it should get the values from column B which 750 in the example, then column A.

  • moizsherwani's avatar
    moizsherwani
    Icon for Continued Contributor rankContinued Contributor
    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] )