Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I'm having trouble multiplying two colums in two tables to get the most recent value.
The tables look like this:
table1 | ||
uid | TickRef | Count |
1 | AB1 | 10 |
2 | AB4 | 20 |
3 | XY2 | 5 |
4 | XY1 | 5 |
table2 | |||
uid | Date | TickRef | Value |
1 | 31/01/2019 | AB1 | 100 |
2 | 31/01/2019 | AB4 | 200 |
3 | 30/06/2019 | XY2 | 10 |
4 | 30/06/2019 | XY1 | 50 |
5 | 30/06/2019 | AB1 | 150 |
5 | 31/07/2019 | XY2 | 20 |
The TickRef in both tables are related and is one to many, table2 having many entries. What I want to achieve is to multiply sum of Count in table1 with the value from table2 with the most recent date.
Expected result should be like this:
Expected Result | |||
TickRef | Sum Count | Latest Value | Product |
AB1 | 10 | 150 | 1500 |
AB4 | 20 | 200 | 4000 |
XY2 | 5 | 20 | 100 |
XY1 | 5 | 50 | 250 |
I can't seem to figure this one. Please help or share a link with solution to a similar problem.
Thanks
Solved! Go to Solution.
Can you please refer the above steps to get the expected result with out DAX.
Can you please refer the above steps to get the expected result with out DAX.
I think summarizing data across table worth exploring
https://community.powerbi.com/t5/Desktop/Summarize-multiple-tables-in-DAX/td-p/642693
User | Count |
---|---|
75 | |
74 | |
44 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |