Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Talal141218
Helper III
Helper III

Get values from another row

Hi Profissionals, 

I have two tables one of them Dimination Tabel and include column with account sheets number ( like customer Nr , Cash discount ), and aonther table is fact table with amounts and invoice number. 

My question is, how can i get all discounts for spicific customer?. 

please look at the screenshot. 

Talal141218_0-1695110869047.png

Please if you need more infos don't hesitate to mention. 

Thanks in advance.

3 REPLIES 3
Talal141218
Helper III
Helper III

Thanks for your Support, Yes we have a relation between two tables. Find the Pic below : 

Talal141218_0-1695127848772.png

 

RSC
Helper I
Helper I

Hi @Talal141218,
could you please tell, do we have any relationship between table?
Or any column on the bases of that you can find the values in other table if so then you use
LOOKUP

CustomerNameLookup = 
LOOKUPVALUE(
    CustomerLookup[CustomerName],
    CustomerLookup[CustomerID], Orders[CustomerID]
)

Thanks 

I want to clairyfy my question : The customers and cash discounts (LedgerAccount)-DIM Table and both have the same invoice number. The Invoice is  a column int the fact- generalledger,but the have different amount in the Fact-Generalledger. The relate i want to create is : Customer Nr. (LedgerAccount)-between 10000 till 29999 and  the invoice number and the amount, which belong to cash discount. In that's way can i get how much discount get every customer. :). 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.