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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
ShelRose
Frequent Visitor

how to show end of Quarterly figures

Hi, 

I'm trying to show end of quarterly values in a Donut chart but not all figures added up. i need it to show

Q1=3482

Q2= 3350

and so on.

 

 

Jan3587 
Feb3551 
Mar3482Q1
Apr3477 
May3403 
Jun3350Q2
Jul3355 
Aug3346 
Sep3514Q3
Oct3493 
Nov3491 
Dec0Q4

 

 

Is this possible to show? thanks in advance 

1 REPLY 1
Sahir_Maharaj
Super User
Super User

Hello @ShelRose,

 

Can you please try this:

 

1. Create a Quarter Identification Column

Quarter =
SWITCH(
TRUE(),
MONTH([Date]) <= 3, "Q1",
MONTH([Date]) <= 6, "Q2",
MONTH([Date]) <= 9, "Q3",
"Q4"
)

2. Create a Measure for End-of-Quarter Values

End of Quarter Value =
CALCULATE(
SUM([Value]),
FILTER(
ALL('Table'),
'Table'[Quarter] = MAX('Table'[Quarter]) &&
'Table'[Month] = EOMONTH(MAX('Table'[Date]), 0)
)
)

Should you require any further assistance, please do not hesitate to reach out to me.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 13K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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