98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Power BI training and help » Lookup and Sum
Lookup and Sum
Resolved · High Priority · Version 365
Emily has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI Reporting course
Lookup and Sum
Hi Everyone,
I am trying to do a look up against a different table... but then i want to sum up the value against each line of the orginal value.
Is this possible please??
Example Info (there is more columns then shown below):
Description Possible Days
200 KVA 36
300 KVA 54
150 KVA 56
200 KVA 72
150 KVA 22
20 KVA 16
300 KVA 31
I need to look up each of the Possible days against each Description and then return the summed total. I have already done a count summary against the description so i know how many of each description there is.
i hoope this makes sense! Please help me out :-)
RE: Lookup and Sum
Hi Emily,
Thank you for your question to the forum
When you say you want to 'sum up the value against each line of the original value' which value is which from your example? It is not clear from your description exactly what you want to achieve.
What I suggest is you do is send us an example of your data - I assume it is in Excel - to info@stl-training.co.uk
I look forward to hearing from you
Kind regards
Martin Sutherland
(IT trainer)
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Master DAX (Data Analysis Expressions)DAX is the formula language used in Power BI for creating custom calculations and aggregations. Invest time in learning DAX to unlock the full potential of Power BI. Understand functions like CALCULATE, FILTER, and SUMX, as they are fundamental for creating complex calculations and measures. |