Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Honda123
Frequent Visitor

DAX SUM WITH GROUP AND PER MONTH

 

Spoiler

Hello Comnunity

how I calculate problem like this to calculate sum with group per month and find correct result for total target per month

I Have 4  Column :

Honda123_0-1654068593951.png

 

i want to calculate sum  target salesforce every month, target is average daily, so per month per sales is same

Honda123_1-1654068613425.png

 



and also i want calculate total target per month that, i want target per month is 15 (target sales a & B), but when i calculate average the value isi 7.5 per month

help me to solve thiss
Thanks

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Honda123 

Calculate(Sumx(Sumamrize(Table,Table[salesforce], [Target]), [Target]) , allexcept(Table[salesforce]))

View solution in original post

3 REPLIES 3
Honda123
Frequent Visitor

Thanks it sovle, 

I really appreciate


amitchandak
Super User
Super User

@Honda123 

Calculate(Sumx(Sumamrize(Table,Table[salesforce], [Target]), [Target]) , allexcept(Table[salesforce]))

can you help me again,
in this case, how i can get total target
that function just average per month, 
i have case to summarize target from januari to februari that mean
jan target is 15
feb target is 15
so jan to feb is 30
in that case summary jan to feb is 15 again

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.