Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
86
Views
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, Michael
Posted : 28/05/2023 4:37 pm
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