Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I want to group customer based on years of transaction using SWITCH function.
For example customer A first transaction in 2010 , last transaction in 2020 , so years of transaction is 10.
Like wise for other customers.
Date Diff(measure)
MAX('Table'[Year ])-MIN('Table'[Year ])
Loyalty(New Column)
Loyalty = SWITCH(TRUE(),
[DateDiff]>=0 && [DateDiff]<=2, "BRONZE",
[DateDiff]>=3 && [DateDiff]<=5, "SILVER",
[DateDiff]>=6 && [DateDiff]<=8, "GOLD")
But the column Loyalty when put in a slicer, it doesnt show all groups.
Please check the sample data.
Thank you in advance.
Solved! Go to Solution.
You need to give it a row context to evaluate the DateDiff before you can do the switch, try doing the datediff as a column in the table:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
You need to give it a row context to evaluate the DateDiff before you can do the switch, try doing the datediff as a column in the table:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |