Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
It might be an easy question but I can't figure out the correct method.
I have a category list
Category | Sub |
A | 1 |
A | 2 |
B | 3 |
B | 4 |
Timestamp | Value | Sub |
5/6/2022 | 40 | 1 |
5/6/2022 | 100 | 3 |
5/6/2022 | 50 | 3 |
I would like to calculate true or false (if 3 value larger than 60 then true, less than 60 then false ; if 1 value larger than 50 then true, less than 50 then false)
Total value
Thanks for your help.
Hi there!
You could try something like this:
SWITCH(
TRUE(),
Sub = 3 && Value > 60, TRUE,
Sub = 3 && Value <= 60, FALSE,
Sub = 1 && Value > 50, TRUE,
Sub = 1 && Value <= 50, FALSE,
BLANK()
)
Let me know if that help!
Make sure to refer to the corresponding column and table, I used sub and value as an example, but it would be 'Total Value'[Sub] and 'Total Value'[Value] instead of just "Sub" and "Value". Also make sure you create this calculated column in Total Value table
Hi @PabloDeheza,
However, I have a list of the value
Timestamp | Value | Sub |
5/6/22 | 5 | 1 |
5/6/22 | 43 | 1 |
5/6/22 | 20 | 1 |
5/6/22 | 6 | 2 |
I wish to get the sum from sub 1 and the value if >50 then true, sub 2>20 then true
So it will be telling me true for 1 because is 68 while false for 2 <20.
Are there any method to do this?
Thanks for your help.
That way would be for a calculated column
Check out the November 2023 Power BI update to learn about new features.