Forum Discussion
Solved
Top N Customers / Products
Hello, I am hoping someone can help me. I am trying to calculate my top 10 customers for the current month to date and the previous month to date to show in a visual alongside each other with the...
Do you mean that you want to show the Top N customers of current month and previous month in the same column chart as below?
If yes, we need to create two tables for current month and previous month, then union these two tables, and use the columns of the union table in a column chart.
CurrentMRank = SUMMARIZECOLUMNS ( Table1[Customer], "CurrentMTD", [CurrentMTD], "PreMTD", [PreMTD], "Rank", [Rank_CurrentMTD], "Type", "CurrentMonth" )PreMRank = SUMMARIZECOLUMNS ( Table1[Customer], "CurrentMTD", [CurrentMTD], "PreMTD", [PreMTD], "PreMRank", [Rank_PreMTD], "Type", "PreMonth" )Current&PreM = UNION ( CurrentMRank, PreMRank )
Best Regards,
Herbert
v-haibl-msft
Microsoft Employee
Microsoft Employee
Do you mean that you want to show the Top N customers of current month and previous month in the same column chart as below?
If yes, we need to create two tables for current month and previous month, then union these two tables, and use the columns of the union table in a column chart.
CurrentMRank =
SUMMARIZECOLUMNS (
Table1[Customer],
"CurrentMTD", [CurrentMTD],
"PreMTD", [PreMTD],
"Rank", [Rank_CurrentMTD],
"Type", "CurrentMonth"
)
PreMRank =
SUMMARIZECOLUMNS (
Table1[Customer],
"CurrentMTD", [CurrentMTD],
"PreMTD", [PreMTD],
"PreMRank", [Rank_PreMTD],
"Type", "PreMonth"
)
Current&PreM = UNION ( CurrentMRank, PreMRank )
Best Regards,
Herbert
Thanks v-haibl-msft!