ashishmehra2020
New Member
Hi,
Happy Sunday !!!
Attaching Input in Excel and Output in Power BI as far as I can
. This is the required Output I am looking for in Power BI.
View attachment 85053
Method 1: Basis user selection of Top N Customers for the Latest Date ; the table should produce.
Method 2: Basis few conditions we want to find the list of Customers refer attached excel file Customer Database Tab: Pivot 2 True Condition
Requirement:
1) Combine both the single columnar Tables without Duplicates
2) User should be able to add or reduce TOP N Customers ; this will helps in getting desired Coverage.
I only need a bit of your support to make the TOP N Table working. Thanks for your valuable time.
Happy to answer if you have any Qs.
Regards,
Ashish Mehra
Happy Sunday !!!
Attaching Input in Excel and Output in Power BI as far as I can
View attachment 85053
Method 1: Basis user selection of Top N Customers for the Latest Date ; the table should produce.
Method 2: Basis few conditions we want to find the list of Customers refer attached excel file Customer Database Tab: Pivot 2 True Condition
Requirement:
1) Combine both the single columnar Tables without Duplicates
2) User should be able to add or reduce TOP N Customers ; this will helps in getting desired Coverage.
I have tried creating "T1 - Top N Customer" but that is static.
T1 - Top N Customer =
TOPN(
10,
'Database',
[CM Sales]
)
My 2nd attempt
Dynamic Top Table =
VAR TopNSelected = SELECTEDVALUE('TopN Selection'[Value])
VAR TopCustTable =
TOPN(
TopNSelected,
'Database',
[CM Sales]
)
RETURN
TopCustTable
I only need a bit of your support to make the TOP N Table working. Thanks for your valuable time.
Happy to answer if you have any Qs.
Regards,
Ashish Mehra