Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
samioberoi
Helper I
Helper I

Naming Academic years as Quarters

Hi

How can i name Academic year Sep till Nov as Q1 and Dec till Jan Q2 so on and so forth? I tried to use switch statement on date dimension, but that changes the count of data on each quarter completely. So, i don't want to change anything on the date dimension, but i just want to name the month ranges like Sep till Nov as Q1 and Dec till Jan Q2 etc.

 

Hoping to get some help on this. 

 

Thanks

1 ACCEPTED SOLUTION

you can create an academic year quarter column or academic year column to fix this.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@samioberoi 

you can try this

academic year = switch(TRUE(),
'date'[month] in {9,10,11},"Q1",
'date'[month] in {12,1,2},"Q2",
'date'[month] in {3,4,5},"Q3",
"Q4")

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi Ryan,

 

Thanks for your help. I tried this swich statement before Asalaam well, but on the visualization it is changing the data. By using this switch statement it brings the 2019 Q4 from the original visualization to Q1. Same for 2020 it brings the Q4 from the first column chart to Q1 after the switch statement. I don't know how i can fix it.

 

Some help on this will be much appreciated.

 

Thanks

 

you can create an academic year quarter column or academic year column to fix this.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.