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.
I'm trying to find a way to connect my date table to a table that includes students' grade reports. The student grade report does not have a true date column. There are two columns that contain text that indicate the school year and term that the grades were earned, like below:
School Yr | Term |
202122 | Fall |
202223 | Winter |
201920 | Spring |
201819 | Winter |
My thought is that I should create a column in my date table that identifies all dates from July 1, 2018-June 30, 2019 as the text 201819 (and all dates from July 1, 2019-June 30, 2020 as 201920 etc) so that I can relate it to the School Year column of the grade reports.
Assuming it's possible, how can I use DAX to create this column?
Solved! Go to Solution.
hi @hannahs5
hi @hannahs5
checked and it worked like this:
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |