Convert Measure to Column

[Anonymous]

Hi, i have a calculated measure but want a column instead because of a filter that i need

see below my calculated column.

First Project =
VAR mydate =
CALCULATE (
MIN ( Projecten[start_date]);
FILTER (
CALCULATETABLE ( VALUES ( Projecten) );
Projecten[start_date] >= Projecten[Datum in dienst]
)
)RETURN
CALCULATE (
MIN ( Projecten[end_customer]);
FILTER (
CALCULATETABLE ( VALUES ( Projecten ));
Projecten[start_date]= mydate
)
)

[v-lili6-msft]

Hi ,@Framboosje

Try this formula please

First Project =
VAR mydate =
    CALCULATE (
        MIN ( Projecten[start_date] ),
        FILTER ( Projecten, Projecten[start_date] >= Projecten[Datum in dienst] )
    )
RETURN
    CALCULATE (
        MIN ( Projecten[end_customer] ),
        FILTER ( Projecten, Projecten[start_date] = mydate )
    )

If it is not your case, please share pbix and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin