Slicer Value with calculted column

[Anonymous]

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

[Ashish_Mathur]

Hi,

You may download my solution PBI file from here.

Hope this helps.

[v-danhe-msft · Accepted 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

[themistoklis]

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