Forum Discussion
DAX QUERY - SUM VLOOKUP
Hi,
I have the below two tables:
Table 1
| Concatenate | Time Spent |
| DE-VAT Return | 2 |
| DE-VAT Return | 3 |
| FR-VAT Return | 7 |
Table 2:
| Concatenate | Count | Sum Time Spent |
| DE-VAT Return | 2 | DAX Formula? (5) |
| FR VAT Return | 1 | DAX Formula? (7) |
What is the DAX formula I need to include in table 2 to add the sum of Time Spent?
Answer can be found here:
https://community.powerbi.com/t5/Desktop/SUMIF-Equivalent-in-DAX/td-p/230727
5 Replies
- amitchandak
Super User
Anonymous , assume the text in the first one is "DE-VAT Return 2"
Use split by column and split it by space into 3 column
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
col1, col2, col3
DE-VAT, Return, 2
Then count(Table[Col1])
time Spend =Sum(Table[Col1])
Hi Anonymous ,
Create a Column in Table1.
Column = CALCULATE (Table1 [TimeSpent]), Filter( Table1, Table1[Concatenate] = EARLIER(Table1[Concatenate])))
Then do a lookup in table 2Lookup value = Lookup (Table1[Column], Table1[Concatenate] , Table2[Concatenate])
Regards,
Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Answer can be found here:
https://community.powerbi.com/t5/Desktop/SUMIF-Equivalent-in-DAX/td-p/230727
