Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |