New to DAX

[mib1019]

I am new to Power Query /PowerBI and have made a start with an online course.

Have chosen a project involving weather history to continue my leanrning. I have only three tables. One is weather history data, acquired from VisualCrossings, which I will append to at the end of each month. It currently holds data for all dates from 2000-2021 for a few locations.

Two other tables are 'Date Lookup' and 'Season Lookup', as shown below:

I want to get the Season for the given date into the Date Lookup table from the Season Lookup table. Is there a DAX formula that would work for this?

Thanks in advance for any help you can give me.

MIB1019

 

[Matt Allington]

Unpivot your seasons table, keeping the year column, unpivot the rest.
this should give you 3 columns, year, attribute (season name start/end), and value (the date).
remove any rows with “end”, keeping the start rows
go to the calendar table and merge the seasons table on date.
extract the attribute column into the calendar
fill down this column
remove the word start from the end

learn how to be awesome with Power BI at Skillwave Training

 

[mib1019]

Well, that was awesome! Love this stuff. Thanks for the help, it worked perfectly!

MIB