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.
Hello All,
We have Dataset like below
ID Name Age
--- ---- ----
10 AAA 40
20 BBB 34
30 CCC 68
40 DDD 58
50 EEE 79
60 FFF 39
70 GGG 28
I want to create slicer visaul with age column like below
Age_Calc
-----
10
20
30
40
50
60
70
80
90
100
I tried to create caluculted column : if(Table1(Age)>10,10,if(Table1(Age)>20,20,.....,If(Table1(Age)>100,100)))..But does not give correct result.
It reruns only
10,100 only instead of 10,20,30..100.
Thanks
Narasimha Reddy
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could refer to below formula:
Column = IF ( [Age] < 20, 10, IF ( 'Table1'[Age] < 30, 20, IF ( [Age] < 40, 30, IF ( [Age] < 50, 40, IF ( [Age] < 60, 50, IF ( [Age] < 70, 60, IF ( [Age] < 80, 70 ) ) ) ) ) ) )
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi,
You may download my solution PBI file from here.
Hope this helps.
Hi @Anonymous,
Based on my test, you could refer to below formula:
Column = IF ( [Age] < 20, 10, IF ( 'Table1'[Age] < 30, 20, IF ( [Age] < 40, 30, IF ( [Age] < 50, 40, IF ( [Age] < 60, 50, IF ( [Age] < 70, 60, IF ( [Age] < 80, 70 ) ) ) ) ) ) )
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Can you try changing the formula and add the AND statement to specify the ranges?
E.g.
IF( AND(Table1(Age)>=0, Table1(Age)<=10) , 10 ,
IF( AND(Table1(Age)>10, Table1(Age)<=20) , 20 ,
IF( AND(Table1(Age)>20, Table1(Age)<=30) , 30 ,
etc
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |