cancel
Showing results for
Did you mean:
Occasional Visitor

## Calculatiing a Sum for the Current Fiscal Year and Previous Fiscal Year

I am new to this blog.  I have searched everywhere for a solution and cannot find one.  My issue I need to calculate the Sum of dollar value for Current Fiscal year, Previous Fiscal Year and Future Fiscal Year.  Here is aan example of my Calculation.

FY 19 \$ Value = Calculate(Sum[Dollar Value],'Complete Data' [Fiscal Year] - 1)

Here are the values in the fiscal year column:

2017

2018

2019

2020

2021

2022

This does not work as the fiscal year column is a text field.  When I convert to a whole Number the fiscal year calculation does not work.

Any help would be greaty appreciated.  Please move this to the correct area as I cant figure out how to get this post there.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Calculatiing a Sum for the Current Fiscal Year and Previous Fiscal Year

Create three measures using dax below:

```Previous Fiscal Year Total = CALCULATE(SUM('Complete Data'[Dollar Value]), FILTER('Complete Data', 'Complete Data'[Fiscal Year] = YEAR(TODAY()) - 1))

Current Fiscal Year Total = CALCULATE(SUM('Complete Data'[Dollar Value]), FILTER('Complete Data', 'Complete Data'[Fiscal Year] = YEAR(TODAY())))

Future Fiscal Year Total = CALCULATE(SUM('Complete Data'[Dollar Value]), FILTER('Complete Data', 'Complete Data'[Fiscal Year] = YEAR(TODAY()) + 1))```

Community Support Team _ Jimmy Tao

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

Community Support Team

## Re: Calculatiing a Sum for the Current Fiscal Year and Previous Fiscal Year

Create three measures using dax below:

```Previous Fiscal Year Total = CALCULATE(SUM('Complete Data'[Dollar Value]), FILTER('Complete Data', 'Complete Data'[Fiscal Year] = YEAR(TODAY()) - 1))

Current Fiscal Year Total = CALCULATE(SUM('Complete Data'[Dollar Value]), FILTER('Complete Data', 'Complete Data'[Fiscal Year] = YEAR(TODAY())))

Future Fiscal Year Total = CALCULATE(SUM('Complete Data'[Dollar Value]), FILTER('Complete Data', 'Complete Data'[Fiscal Year] = YEAR(TODAY()) + 1))```

Community Support Team _ Jimmy Tao

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

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,017 guests
Recent signins: