Forum Discussion

GKrishna's avatar
GKrishna
Regular Visitor
3 years ago

DAX formula

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.

 

CustomerPeriodRequestRevenue
ABCJan , 2023A$1.
XYZJan , 2023B$2.
XYZFebruary, 2023B$4.
SDGFebruary, 2023C$5.
FGKFebruary, 2023A$8.
FTGMarch ,2023B$9.
ABCMarch ,2023C$10.
Need Help

2 Replies

    • GKrishna's avatar
      GKrishna
      Regular Visitor
      3 years ago

      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