Forum Discussion
Post ProdigyIndex column based two linked tables from direct query
Hi,
I have two tables coming fromdirect query
1. First Table: Customer
2. Second Table: Item Name
I created a report linking customer table to Item table. Based on 'Customer'[Customer], and 'item'[Item Name] combination i added Gross Sales. i would like add a index column to add row numbers. There is RankX(Allselected(...) formula however that formula works if all variables come from the same table. In this incidence its cming from two seperate tables from direct query. Did anyone come across similar issue and have a solve for it?
Thanks
Hi dokat ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi dokat ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
dokatThank you i was able to find a workaround. I am all set