Forum Discussion

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
3 years ago
Solved

conditional statement by name for weekly totals

I am trying to get total available hours by week which is usually 40 but one person works 20. In trying to get this in the table by person by week Is there a conditional statement I can use? if na...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi electrobrit ,

    Try

        Working Hours = 

    SWITCH(
        TRUE(),
        SELECTEDVALUE(Sheet1[Name]) = "John",20,40)


    BR

Dinesh_Suranga's avatar
Dinesh_Suranga
Icon for Continued Contributor rankContinued Contributor
3 years ago

electrobrit

Hi,

Use following DAX formula.

Column = IF(SELECTEDVALUE(-AvailHours[narrative_full_name]) = "John", 5*4,5*8)
If it works, Please accept it as solution.

Thank you.