• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Joining Two Single Columnar Table based on only 2 conditions

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 have tried creating "T1 - Top N Customer" but that is static.
T1 - Top N Customer =
TOPN(
10,
'Database',
[CM Sales]
)
My 2nd attempt o_O
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
 

Attachments

  • Database - V02.zip
    131.4 KB · Views: 0
  • Customer Database.xlsx
    103.7 KB · Views: 0
Back
Top