Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago
Solved

Get column value where variable value matches another column value.

I have a calculated column where I can creating a specific calculation similar to below...   Test = ... VAR BackfillRequiredWithinDays = CALCULATE(MIN('Table: Absence Master List'[12) Backfilled...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    StuartSmith 

     

    date. 

    you can change the type to date for the new caluclated column . 

    but leaving it this way also works and wont affect anything . 

     

     

    for the red line, 

    this is an intellisense bug, i guess

    however you can get rid of it : 

     

    Column =
    var ids =  table10[ID]

     

    return
    SELECTCOLUMNS(
    FILTER(
        table10,
        table10[ID]  = ids && table10[Rank] = 3
    ),
    "@col" , [AbsenceDate]
    )

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly.

     

     

     

sayaliredij's avatar
sayaliredij
Icon for Solution Sage rankSolution Sage
2 years ago

Hi StuartSmith 

 

It would help to understand the first part of the DAX

VAR BackfillRequiredWithinDays = CALCULATE(MIN('Table: Absence Master List'[12) Backfilled Required within Days]))

How this other table look like?

Thanks,

Sayali