lookup and sum

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Lookup and Sum

Lookup and Sum

resolvedResolved · High Priority · Version 365

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.

 

Training courses

 

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
What does 'Resolved' mean?

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.

View all Power BI hints and tips


Server loaded in 0.09 secs.