Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Measure to Total each Period Spent using Year to Date Spent for each service

Trying to create a dashboard - part to show total spent per period.  Unable to as all spent amount are year to date spent per serivce, hence all values either doubled, tripled or more.. 

Is there a way to sum the total per period?

Example of data as per below:


Period No Service YTD Total Spent
Jul-21 A 10000
Aug-21 A 11000
Sep-21 A 11100
Oct-21 A 15000
Nov-21 A 15500
Dec-21 A 20000
Jul-21 B 599
Aug-21 B 1000
Sep-21 B 3000
Oct-21 B 3500
Nov-21 B 5000
Dec-21 B 9000
Jul-21 C 0
Aug-21 C 400
Sep-21 C 900
Oct-21 C 1500
Nov-21 C 2000
Dec-21 C 3000


Thank you

Community Support
Community Support

Hi @SushiSashimi1 ,

According to your description, in my understanding, you only have YTD spend for each period and service, now you want the total spend for each period and service.

Actually the last YTD data in that period is the total of that period


If there're many years in your sample and you want to calculate total in each year, you can firstly create a custom column in Power Query.


Year = [Period No]

Then select the custom column and click Extract>Text After Delimiter.



Get the year column.


Then create a measure.

Measure =
    FILTER (
        ALL ( 'Table' ),
        'Table'[Service] = MAX ( 'Table'[Service] )
            && 'Table'[Year] = MAX ( 'Table'[Year] )
    'Table'[YTD Total Spent]

Get the result.


I attach my sample below for your reference.


Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Thank you for your guidance and sorry for not being very clear of what I wanting to achieve.

I am using your pbix and put in additional visual note to explain: multi select - Jul & Aug, it will just sum both value together... maybe it's an easy fix but I just cant my head around it.. 


Total sum not correct:

SushiSashimi1_1-1664835657603.pngService A should be 11000, Service B should be 1000, Service B should be 400


Super User
Super User

What is the expected outcome based on your sample data?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors