Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a column with daily records of rainfall. I want to create a new column that calculates if a certain day is above/below the average rainfall over the course of the year.
It should go something like IF(Rainfall, > Average(Rainfall), "Above Average", < Average(Rainfall), "Below Average")
Clearly this measure is wrong, just wanted to give an idea of what I'm trying to accomplish, thanks!
Solved! Go to Solution.
Hi @water-guy-5 ,
You can follow the blow steps to get it:
1. Create a measure to get the average of rainfall
Average of rainfall = CALCULATE ( AVERAGE ( 'Table'[Rainfall] ), ALLSELECTED ( 'Table' ) )
2. Create a calculated column to get the value which shows above or below average
Column =
IF (
'Table'[Rainfall] > [Average of rainfall],
"Above Average",
IF (
'Table'[Rainfall] < [Average of rainfall],
"Below Average",
"Equal Average"
)
)
Best Regards
Hi @water-guy-5 ,
You can follow the blow steps to get it:
1. Create a measure to get the average of rainfall
Average of rainfall = CALCULATE ( AVERAGE ( 'Table'[Rainfall] ), ALLSELECTED ( 'Table' ) )
2. Create a calculated column to get the value which shows above or below average
Column =
IF (
'Table'[Rainfall] > [Average of rainfall],
"Above Average",
IF (
'Table'[Rainfall] < [Average of rainfall],
"Below Average",
"Equal Average"
)
)
Best Regards
The below logic should work:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!