Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Creating one Dax formula for multiple IF statements

  @ links to members, content   Hello I need assistance in getting this IF statement to work in Dax formula.  I am trying to group my data based on gift amounts.  I have tried the grouping functio...
Need Help
Show and Tell
Tips and Tricks
Bmejia's avatar
Bmejia
Super User
3 years ago

Can something like this work for you using a Switch True Statement

NewColumn = SWITCH(TRUE(),
('Switch'[Gift Amount]>=10 && 'Switch'[Gift Amount]<99.99) && 'Switch'[Gift Cycle]="Recurring","Recurring 10-99.99",
('Switch'[Gift Amount]>=100 && 'Switch'[Gift Amount]<249.99) && 'Switch'[Gift Cycle]="Recurring","Recurring 100-249.99",
('Switch'[Gift Amount]>=10 && 'Switch'[Gift Amount]<499.99) && 'Switch'[Gift Cycle]="Single","Single 10-499.99",
('Switch'[Gift Amount]>=500 && 'Switch'[Gift Amount]<999.99) && 'Switch'[Gift Cycle]="Single","Single 500-999.99",
"1000+"
)