cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Running Daily for the last 14 days

Hi All,

From a single table I need to sum the number of rows 'NSW'[cases] for the last 14 days everyday. So each day in the line chart shows the sum for the previous 14 days.

I've tried the following measures;

14 days = CALCULATE(SUM('NSW'[Cases]),

DATESINPERIOD('Date Table'[Date],MAX(NSW[notifcation_date]),14,day)

running total = CALCULATE(SUM('NSW'[Cases]),

FILTER(

I created a cases column with a numeric

Hope this is clear and has enough information.

Thanks for any help

1 ACCEPTED SOLUTION
Super User

G'day @ringovski

Try this:

``````14 days =
VAR _D =
MAX ( NSW[notifcation_date] )
VAR _14D = _D - 13
RETURN
CALCULATE (
SUM ( 'NSW'[Cases] ),
FILTER (
ALL ( 'NSW' ),
NSW[notifcation_date] >= _14D
&& NSW[notifcation_date] <= _D
)
)``````

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

New Year Power BI eCard:

https://community.powerbi.com/t5/Data-Stories-Gallery/Happy-New-Year/td-p/2266398

Super User

G'day @ringovski

Try this:

``````14 days =
VAR _D =
MAX ( NSW[notifcation_date] )
VAR _14D = _D - 13
RETURN
CALCULATE (
SUM ( 'NSW'[Cases] ),
FILTER (
ALL ( 'NSW' ),
NSW[notifcation_date] >= _14D
&& NSW[notifcation_date] <= _D
)
)``````

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

New Year Power BI eCard:

https://community.powerbi.com/t5/Data-Stories-Gallery/Happy-New-Year/td-p/2266398

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors
Top Kudoed Authors