Forum

Need help about a m...
 
Notifications
Clear all

Need help about a measure in Powerpivot

2 Posts
2 Users
0 Reactions
86 Views
(@excel_f)
Posts: 1
New Member
Topic starter
 

Dear experts,

I have import two tables in the datamodel, please find attached:

I would write a measure so that each turnover(Umsatz) per Month will be multiplicated with the percentage of rebate (Abzug)

These two tables are having a relationship by (SORTE)

Is someone there who can support me.

Thanks in advance

best, MichaelTabelle-1-Datenmodell-1.png

Tabelle-2-Datenmodell.png

 
Posted : 28/05/2023 4:37 pm
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

Not sure is this is what you asked for and there could be better ways to do it. DAX isn't my strongest point.

Have a look at the attached workbook and come back here if you get stuck.

 
Posted : 29/05/2023 3:11 am
Share: