Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi team,
I'm having different customers with Request type ( A,B,C,D) for 2022 to till date period with revenue now required like A will be revenue by total revenue per month like so B will be revenue by total revenue per month like so C as well. required DAX forumla.
Customer | Period | Request | Revenue |
ABC | Jan , 2023 | A | $1. |
XYZ | Jan , 2023 | B | $2. |
XYZ | February, 2023 | B | $4. |
SDG | February, 2023 | C | $5. |
FGK | February, 2023 | A | $8. |
FTG | March ,2023 | B | $9. |
ABC | March ,2023 | C | $10. |
Sorry @GKrishna but is nearly impossible to understand what you are asking for.
Hi,
I required values like a
1)ABC customer in Jan 2023 with Request type A revenue with total revenue with per month again 2)XYZ Customer in Jan 2023 with Request type B revenue with total revenue within jan month data
3) XYZ Customer in Feb 2023 with request type B revenue with total revenue with in per month like that.
in simple words customer with request type with revenue by total revenue divide per month
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |