Forum Discussion
KW123
Helper V
Helper VYear Diff with Slicer
Hi, I have a column that shows the year difference between opening and account and closing the account. I'd like to make a slicer which has the following options SLICER: <1 year 1-3 years ...
Hi ,
How about this:
SWITCH ( TRUE, 'Query1'[Year Diff] < 1,"<1", 'Query1'[Year Diff] >= 1 && 'Query1'[Year Diff] <= 3,"1-3", 'Query1'[Year Diff] >= 4 && 'Query1'[Year Diff] <= 5,"4-5", ">5" )
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi ,
How about this:
SWITCH (
TRUE,
'Query1'[Year Diff] < 1,"<1",
'Query1'[Year Diff] >= 1 && 'Query1'[Year Diff] <= 3,"1-3",
'Query1'[Year Diff] >= 4 && 'Query1'[Year Diff] <= 5,"4-5",
">5"
)
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
KW123Helper V
Helper Vtackytechtom
Thank you so much, this is exactly what I am looking for!