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 all,
New to Power BI. I'm trying to chart Growing Degree Days (which is a temperature/weather related thing), by crop growing season.
I'm in the the southern hemisphere, so our growing season is September - April. I would like to have a "Season" colum in the date table. And as an example Season20-21 would indicate any date between 1 September 2020-30 April 2021.
I've read a bit about doing date tables in DAX vs M or others, I think I'm happy to do this in DAX.
I have found plenty of examples using financial periods, but not sure how to best to go about doing this based on the above.
Any ideas or staring pointers appreciated.
thanks
@sossie07 , In your date table create a new column like
season =
var _year = Switch(True(), month([date]) >=9 ,year([Date]) ,
month([date]) <=4 ,year([Date]) -1 )
return
if(month([date]) >=9 && month([date]) <=4,"Switch " & _year & "-" & (_year +1) , blank())
Thanks Amitchandak,
I couldn't actually get your solution to work, but it got me started.
I ended up with this:
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |