information needed not only in dax, but also as logic

[cristianj]

i have a tabel like this :
id      | Differences |

1      | -3

2     |-10

3      |0

4      |4

....

i want to have a tabel which look like this

[v-yadongf-msft]

Hi @cristianj ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

[v-yadongf-msft · Accepted solution]

Hi @cristianj ,

Please try following DAX:

Interval = SWITCH(
    TRUE(),
    'Sheet6'[difference]<-5,"<$-5",
    'Sheet6'[difference]>=-5 && 'Sheet6'[difference]<=0,"$-5<->$0",
    'Sheet6'[difference]>0 && 'Sheet6'[difference]<=10,"$1<->$10",
    'Sheet6'[difference]>10 && 'Sheet6'[difference]<=18,"$11<->18")

Then create a table visual and you can get result you want.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@cristianj sorry your question is not clear and the sample and the output don't explain what you are trying to achieve. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[cristianj]

Sorry , i have a table in which i have model and difference of price for each line, i want to make a table in which i want to count how many lines i have in each interval.