Power BI Decision-Making Dashboard | Aurora Bank Analysis - Part One

[@SandyCoco1]

Getting my learning materials ready. Thanks for sharing your knowledge with us ❤

[@ZefasBi-Analytics]

Will add that to the file on one drive now

[@isBessem]

Great work! The only observation I have is about the Canva settings that must be set to 16:9 in case people would like to participate in challenges like in your example 🤗

[@BcConnect]

great but no code for the calender dax

[@BcConnect]

great video
i got stuck at 21:39 because the code aint bright enough and you did include the code in the Aurora Dax docx file

[@ZefasBi-Analytics]

done check please

[@BcConnect]

@@ZefasBi-Analytics i used gpt to extract the text from the video

[@BcConnect]

thats fine thanks

[@BcConnect]

what about the continuation ?

[@ZefasBi-Analytics]

Tomorrow almost done

[@BcConnect]

calendar =
VAR BaseCalendar =
CALENDAR(DATE(2012, 1, 1), DATE(2014, 12, 31))
RETURN
ADDCOLUMNS(
BaseCalendar,
"Year", YEAR([Date]),
"Quarter", QUARTER([Date]),
"Month", MONTH([Date]),
"Week Number", WEEKNUM([Date]),
"Week Day", WEEKDAY([Date]),
"Day", DAY([Date]),
"Month Name", FORMAT([Date], "MMMM"),
"Month Sort", FORMAT([Date], "YYYY MM"),
"Quarter Number", "Q" & QUARTER([Date]),
"Year Month", FORMAT([Date], "YYYY MMMM"),
"Year Month Sort", YEAR([Date]) * 100 + MONTH([Date]), -- Sortable Year-Month column
"Weekend?", [Date] = 0 + WEEKDAY([Date])
)