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

## CALCULATE Last Fiscal Year's Total

This is the measure I'm using to calculate total gifts to date in the current fiscal year.

How can I modify it to create another measure to find total gifts for all of last fiscal year?
1 ACCEPTED SOLUTION
Super User

Hi @PBrainNWH - Sorry,

can you try either sameperiodlastyear or parallelperiod function from dax

Below logic i am sharing with Paralleperiod function.

CALCULATE(
DATESYTD(
PARALLELPERIOD(Opportunity[CloseDate], -1, YEAR),
"6/30"
)
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!

4 REPLIES 4
Super User

Hi @PBrainNWH Create a measure that calculates the total gifts for the last fiscal year.

Create below measure and check:

CALCULATE(
DATESBETWEEN(
Opportunity[CloseDate],
DATE(YEAR(TODAY())-1, 7, 1),
DATE(YEAR(TODAY()), 6, 30)
)
)

assuming FY ends with June.

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!

Helper II

The calculation GiftsLastFY is giving me the total for every day of the last fiscal year. I'm testing on one record and they have one \$10,000 gift in last fiscal year.

Super User

Hi @PBrainNWH - Sorry,

can you try either sameperiodlastyear or parallelperiod function from dax

Below logic i am sharing with Paralleperiod function.

CALCULATE(
DATESYTD(
PARALLELPERIOD(Opportunity[CloseDate], -1, YEAR),
"6/30"
)
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!

Helper II

ParallellPeriod seems to work! Thank you.

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.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors