Forum Discussion

kristi_in_heels's avatar
kristi_in_heels
Helper II
2 years ago
Solved

If then DAX help

Hello,   I have a number of different sheets, with date columns. I am trying to create a card visual which will pull 2 relevant dates based on the project phase, and then a calculation between the ...
Need Help
  • devesh_gupta's avatar
    devesh_gupta
    2 years ago

    kristi_in_heels  You can create DAX measures which uses Switch function for the above mentioned conditions by you.

     

    Result 1 (Card 1):

    Result1 =
    VAR PhaseDescription = SELECTEDVALUE('All Projects'[ProjectPhaseDescription])
    RETURN
    SWITCH (
    TRUE (),
    PhaseDescription = "execution", SELECTEDVALUE('All Projects'[ExecutionStartDate_Actual]),
    PhaseDescription = "Prefeasibility", SELECTEDVALUE('All Projects'[PrefeasibilityStartDate_Actual]),
    PhaseDescription = "Feasibility", SELECTEDVALUE('All Projects'[FeasibilityStartDate_Actual]),
    BLANK ()
    )

     

    Result 2 (Card 2):

    Result2 =
    VAR PhaseDescription = SELECTEDVALUE('All Projects'[ProjectPhaseDescription])
    RETURN
    SWITCH (
    TRUE (),
    PhaseDescription = "execution", SELECTEDVALUE('BudgetDates'[EXE]),
    PhaseDescription = "Prefeasibility", SELECTEDVALUE('BudgetDates'[PFS]),
    PhaseDescription = "Feasibility", SELECTEDVALUE('BudgetDates'[FS]),
    BLANK ()
    )

     

    Calculation (Card 3):

    Calculation = [Result2] - [Result1]

     

     

    Try this if it helps.

     

devesh_gupta's avatar
devesh_gupta
Impactful Individual
2 years ago

kristi_in_heels  You can create DAX measures which uses Switch function for the above mentioned conditions by you.

 

Result 1 (Card 1):

Result1 =
VAR PhaseDescription = SELECTEDVALUE('All Projects'[ProjectPhaseDescription])
RETURN
SWITCH (
TRUE (),
PhaseDescription = "execution", SELECTEDVALUE('All Projects'[ExecutionStartDate_Actual]),
PhaseDescription = "Prefeasibility", SELECTEDVALUE('All Projects'[PrefeasibilityStartDate_Actual]),
PhaseDescription = "Feasibility", SELECTEDVALUE('All Projects'[FeasibilityStartDate_Actual]),
BLANK ()
)

 

Result 2 (Card 2):

Result2 =
VAR PhaseDescription = SELECTEDVALUE('All Projects'[ProjectPhaseDescription])
RETURN
SWITCH (
TRUE (),
PhaseDescription = "execution", SELECTEDVALUE('BudgetDates'[EXE]),
PhaseDescription = "Prefeasibility", SELECTEDVALUE('BudgetDates'[PFS]),
PhaseDescription = "Feasibility", SELECTEDVALUE('BudgetDates'[FS]),
BLANK ()
)

 

Calculation (Card 3):

Calculation = [Result2] - [Result1]

 

 

Try this if it helps.

 

kristi_in_heels's avatar
kristi_in_heels
Helper II
2 years ago

Thank you, this worked perfectly. I really appreciate your assistance.