Solved: Calculate sum of the past 3 months - Page 2

CourtneyLeah · ‎01-19-2017

Hi guys,

I'm fairly new to Power BI and my DAX knowledge is fairly limited, so bear with me.

I have a tabel with the following information:

Month Start, Company, # Safety Briefings for month

1/01/2016, Company A, 5

1/01/2016, Company B, 10

1/01/2016, Company C, 15

1/02/2016, Company A, 6

1/02/2016, Company B, 4

1/02/2016, Company C, 6

etc

What I want to do is calculate the total number of safety briefings completed over the past 3 months.

I have tried creating a new measure using the following:

Safety Briefings last 3 months = CALCULATE(sum(Table1[Safety Briefings]), DATESINPERIOD(Table1[Start Date], LASTDATE(Table1[Start Date]), -3, MONTH))

However, this only gives me the total for the month, NOT the past 3 months.

Any help would be greatly appreciated.

Cheers

GilbertQ · ‎01-19-2017

Hi @CourtneyLeah, it would be best to have a Date Table and link your Month Start to the date table.

If that is done you could then create the following calculated measure which should work for you.

Safety Briefings last 3 months =
CALCULATE (
    SUM ( Table1[Safety Briefings] ),
    DATEADD ( 'Date'[Calendar Date], -3, MONTH )
)

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Calculate sum of the past 3 months