Solved: Month and quarter Value

rajasekar_o · ‎03-26-2024

hi team,
I want to display the values as shown in the table below.
How to Achive this .

	Jan	Feb	Mar	Q1	Apr	May	jun	Q2	Jul	Aug	Sep	Q3	Oct	Nov	Dec	Q4	Total
2020	10	10	10	30	10	10	10	30	20	30	40	90	10	20	30	60	210
2021	20	10	30	60	23	12	10	45	10	10	10	30	20	20	80	100	204

danextian · ‎03-27-2024

Hi @rajasekar_o ,

You will need a disconnected table containing the periods (month, quarter) and some advanced DAX to achieve that. Please see attached pbix for reference.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

danextian · ‎03-27-2024

Hi @rajasekar_o ,

You will need a disconnected table containing the periods (month, quarter) and some advanced DAX to achieve that. Please see attached pbix for reference.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Month and quarter Value

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - February 2025

Fabric Community Update - March 2025

How to Get Your Question Answered Quickly

Join us at the 2025 Microsoft Fabric Community Conference