Date DAX Expressions

[kdaya]

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, 

[Eric_Zhang · Accepted solution]

---

@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, 

---

@kdaya

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.

[Greg_Deckler]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490