Forum Discussion
Date DAX Expressions
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 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.
2 Replies
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.
