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,
I have a Program Year Age calculation (Calculated Column) based on a formula.
There is another column Single Risk Indicator which can only have 2 values viz. Y and N. I want the above formula for Program Year Age to be always calculated only for Single Risk Indicator = 'N'.
How do I implement this condition based formula.
Please show and help if possible.
Thanks,
Vishy
Solved! Go to Solution.
You want to calculation Program Year Age to only occur if the Single Risk Indicator = 'N''?
If that is the case you need an IF statement:
IF( [Single Risk Indicator] = "N" , [Program Year Age] , BLANK() )
You want to calculation Program Year Age to only occur if the Single Risk Indicator = 'N''?
If that is the case you need an IF statement:
IF( [Single Risk Indicator] = "N" , [Program Year Age] , BLANK() )
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |