Forum Discussion

J94's avatar
J94
Advocate II
1 year ago
Solved

Date hierarchy

Hello everyone,   I have a graph with year and month in the x axis, which work nicely (see screenshot). This is coming from a data hierarchy, created by Power BI itself when in Time Intelligence au...
Need Help
  • quantumudit's avatar
    quantumudit
    1 year ago

    Hello J94 

    The EOMONTH() function can be utilized to retrieve the last date of the month, formatted as "mmm-yy".

     

    This approach ensures that the datatype remains intact, meaning the MonthYear column retains its date/time datatype rather than being converted to categorical.

     

    By applying this method, the desired outcome should be achieved. An image illustrating a scenario is attached. Kindly implement the same technique and inform us if the issue persists.

     

     

    Best Regards,
    Udit

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudo 👍

    🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
    ✨ Visit My Linktree: LinkTree

    Proud to be a Super User

     

     

     

quantumudit's avatar
quantumudit
Super User
1 year ago

Hello J94 

The EOMONTH() function can be utilized to retrieve the last date of the month, formatted as "mmm-yy".

 

This approach ensures that the datatype remains intact, meaning the MonthYear column retains its date/time datatype rather than being converted to categorical.

 

By applying this method, the desired outcome should be achieved. An image illustrating a scenario is attached. Kindly implement the same technique and inform us if the issue persists.

 

 

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User