Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Events In Progress with other conditions.

Hi all, I have quite a complicated issue, with doing a events in progress with muiltpe outcomes. I've managed to do the code in Excel but I'm unsure how to translate this into DAX. I would basically...
DAX
Excel formula
if
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , to me $J$1 seem like static value , that you can have in var

 

Var _val = <Value of $j1>

return

=IF(OR(B2="Break/Paused",[C]=0),B2,IF(_val <[C],"Not Started",IF(AND(_val >[C],_val<[D],[D]<>0),"In Progress",IF([B]="In Progress","In Progress",IF([D[="Withdrawn","Withdrawn","Completed")))))

 

You can also use switch true

 

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

Thanks for getting back to me. I didn't explain it, but J$1 would be the dates in the slicer it would be checking through. 

How I want it to work is to be able to slice down date ranges, so for example  “how many pet adoptions were live between 01/04/2021 – 01/04/2022”I want my dashboard to be able to count the number of pet adoptions that are in progress during sliced times.