DAX formula

[GKrishna]

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.

[guibenassi]

Sorry @GKrishna but is nearly impossible to understand what you are asking for.

[GKrishna]

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