@kdaya wrote:
Hi Community,
Can anyone help me on how i can caluclate data for first 3 month and data after the first 3 months,
Thank you inadvance,
You need a calendar table which has a rank column ranking by the Months of dates.
Then create two measures
top 3 values = SUMX( TOPN(3,'table',RELATED('calendar'[rank]),ASC),'table'[value])
after top 3 measures = SUM('table'[value])-[top 3 values]
See more details in the attached pbix file.
By the way, this is the demo all based on my assumption, to get more straightforward solution, you'll follow @Greg_Deckler's link.
@kdaya wrote:
Hi Community,
Can anyone help me on how i can caluclate data for first 3 month and data after the first 3 months,
Thank you inadvance,
You need a calendar table which has a rank column ranking by the Months of dates.
Then create two measures
top 3 values = SUMX( TOPN(3,'table',RELATED('calendar'[rank]),ASC),'table'[value])
after top 3 measures = SUM('table'[value])-[top 3 values]
See more details in the attached pbix file.
By the way, this is the demo all based on my assumption, to get more straightforward solution, you'll follow @Greg_Deckler's link.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
