Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I need a hand with a Dax formula
I got the following data set:
Date Time T°
1-1-2011 0:30 3
1-1-2011 01:00 3,5
1-1-2011 01:30 3
1-1-2011 02.00 3
Etc
I've made the following chart
With the Max and Min temperature of each day and 2 min and max lines at 10°C and 20°C
Now, what I need is to count all the days that the min temperature is over or equal to 10°C and lower or equal to 20°C to display in a labbel
Thanks you very much for the help
Solved! Go to Solution.
@Alopez11 Try:
Count =
COUNTROWS(
FILTER(
SUMMARIZE('Table',[Date],"__Min",MIN('Table'[T])),
[__Min] >= 10 && [__Min] <= 20
)
)
@Alopez11 Try:
Count =
COUNTROWS(
FILTER(
SUMMARIZE('Table',[Date],"__Min",MIN('Table'[T])),
[__Min] >= 10 && [__Min] <= 20
)
)
Hello @Greg_Deckler
thanks for your help, is now working
I have to make an upgrade to your formula as only use the Min value and not the Max so I made the following
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |