Forum Discussion

prajwaljm24_'s avatar
prajwaljm24_
Frequent Visitor
3 years ago
Solved

can anyone convert this dax to m code

Column =
VAR CurrentSession = [sessionId]
VAR NonNullProject = CALCULATE(MAX([projectId]),
                     FILTER('DS_Tracker (2)', [sessionId] = CurrentSession
                           && NOT(ISBLANK([projectId]))))
RETURN IF(ISBLANK([projectId]), NonNullProject, [projectId])

can anyone convert this Dax to M code
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi prajwaljm24_ ,

     

    Please try this code to create a custom column in Power Query Editor.

     

    let _NonNullProject =
let _CurrentSession = [sessionId]
in
List.Max(Table.SelectRows(#"Changed Type",each [sessionId] = _CurrentSession)[projectId])
in
if [projectId] = null then _NonNullProject else [projectId]

     

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi prajwaljm24_ ,

     

    Please try this code to create a custom column in Power Query Editor.

     

    let _NonNullProject =
let _CurrentSession = [sessionId]
in
List.Max(Table.SelectRows(#"Changed Type",each [sessionId] = _CurrentSession)[projectId])
in
if [projectId] = null then _NonNullProject else [projectId]

     

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    prajwaljm24_ , Try like

    Column =
    VAR CurrentSession = Max('DS_Tracker (2)'[sessionId])
    VAR NonNullProject = CALCULATE(MAX([projectId]),
    FILTER(allselected('DS_Tracker (2)'), [sessionId] = CurrentSession
    && NOT(ISBLANK([projectId]))))
    RETURN IF(ISBLANK([projectId]), NonNullProject, [projectId])