Forum Discussion

hugo_barbara's avatar
hugo_barbara
Icon for Helper I rankHelper I
3 years ago
Solved

Creating a calculated column that brings the first value that appears according to other lines

Guys, All good? Is there a way to create a calculated column that brings the first time such a condition appears in another column. For example, I have a table that shows the week by week evolutio...
"DAX"
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi hugo_barbara 

    Please try

    Flag =
    IF (
    MINX (
    FILTER (
    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[UNIDADE] ) ),
    'Table'[Progresso] = 1
    ),
    'Table'[DATA]
    ) = 'Table'[DATA],
    "True"
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi hugo_barbara 

Please try

Flag =
IF (
MINX (
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[UNIDADE] ) ),
'Table'[Progresso] = 1
),
'Table'[DATA]
) = 'Table'[DATA],
"True"
)