Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Visualize data with Power BI / Video 9 issue with Sch...
Visualize data with Power BI
Unanswered

Video 9 issue with SchoolYear Matrix

(4) ShareShare
ReportReport
Posted on by CU15081528-6 10
I am following along in the Power BI section and around video 9 when we insert our first matrix with the Loans and student information, the years/months stop displaying and all of the rows show 968 unless I select student information from the bar graph connected to it. I followed, step-by-step, but I seem to be missing somethiing
Categories:
General Discussion
need help.png
  • CU08102047-0 Profile Picture
    CU08102047-0 9 on at
    Video 9 issue with SchoolYear Matrix
    Hello,
     
    I think that you should look in the relationship between dimdate and the loans. You might have a different format between dimDate!date and Loans!Date Loan Start Date. Once you have the same format, it should work.
     
    Hope it can help
    Regards,
    ed
  • Suggested answer
    CU15100110-0 Profile Picture
    CU15100110-0 4 on at
    Video 9 issue with SchoolYear Matrix
    Use this updated formula.
     
    dimDate = ADDCOLUMNS(
        CALENDAR(DATE(2019, 1, 1), DATE(2021, 9, 26)), // Define the custom date range
        "MonthID", MONTH([Date]),
        "Month", FORMAT([Date], "MMM"),
        "DayNumber", DAY([Date]),
        "DayName", FORMAT([Date], "dddd"),
        "DayID", WEEKDAY([Date], 2), // 2 means Monday as the start of the week
        "Year", YEAR([Date]),
        "Today", TODAY(),
        // Add a SchoolYear column that adjusts the year based on the month
        "SchoolYear", IF(
            MONTH([Date]) >= 9,
            YEAR([Date]) + 1,
            YEAR([Date])
        ),
        // Adjusts the month to fit the school year, starting from September
        "SchoolMonthID", IF(
            MONTH([Date]) >= 9,
            MONTH([Date]) - 9,
            MONTH([Date]) + 3
        ),
        "Report Refresh", NOW() // We'll use this to display the report refresh date
    )
  • Suggested answer
    CU30081740-2 Profile Picture
    CU30081740-2 5 on at
    Video 9 issue with SchoolYear Matrix
    Hi, I was able to resolve the issue by using CALENDAR function instead of the CALENDARAUTO function. Just provide a start date and end date that encompasses all the data in your Loans table. 
     
    Hope that helps !
    John
  • CU07081254-1 Profile Picture
    CU07081254-1 5 on at
    Video 9 issue with SchoolYear Matrix
    I have the same problem, have you found a solution ?
     
    I am grateful for any help

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,008

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,531

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans