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 / SCHOOLYEAR HIERARCHY V...
Visualize data with Power BI
Unanswered

SCHOOLYEAR HIERARCHY VISUALIZATION

(2) ShareShare
ReportReport
Posted on by CU05080821-0 12
Good day, 
 
please I'm in need of assistance on my schoolyear hierarchy visualization. 
When I bring it in, it doesn't show me the values (year & month data) it's just blank and I'm unable to flow with the rest of the lessons. 
below is a screenshot of what it looks like. 
 
 
Categories:
General Discussion
Screenshot (37)_L...
  • CU15100110-0 Profile Picture
    CU15100110-0 4 on at
    SCHOOLYEAR HIERARCHY VISUALIZATION
    Use this updated formula and then you can continue.
     
    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
    SCHOOLYEAR HIERARCHY VISUALIZATION
    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
  • Suggested answer
    FLMike Profile Picture
    FLMike 28,855 on at
    SCHOOLYEAR HIERARCHY VISUALIZATION
    Hi I am sorry, but for some reason your picture isn't viewable, can you try to add it again and if you need to, paste it as large as you can in the Response.

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