Log In
Register
Home
Need help about a measure in Powerpivot
Michael Zandt
New Member
Members
Forum Posts: 1
Member Since:
May 28, 2023
May 28, 2023
Offline1
May 28, 2023 - 6:37 am
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
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Power BI
Trusted Members
Moderators
Power BI
Forum Posts: 605
Member Since:
January 31, 2022
January 31, 2022
Offline2
May 28, 2023 - 5:11 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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Susan VanRiper, Sue Hammond, Lee Mapes, Lorna Henning, Joaquim Amorim, Shoua Lee
Guest(s) 6
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32817
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —