cancel
Showing results for
Search instead for
Did you mean:
Regular Visitor

Fiscal Year for Previous Year

I have a problem. I have a Period Date which has a Year option. It has a month, year, etc hierarchy. There is a problem when having the previous year to date. The FY is from April, Year(XX), to March Year (XX). I need to calculate from YTD for PeriodDT, if current PeriodDT is this month, or current month, for last years NET. SO, if i choose PeriodDT 2019, it will show all NET from last year up to todays month. Attached pbi.

I also need to choose location, to show the FYTD NEt and Previous YTD Net

https://www.dropbox.com/s/shep5bn6kbvvzfd/GURU%20Test.pbix?dl=0

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super Contributor

Re: Fiscal Year for Previous Year

First of all, create a calendar table

https://docs.microsoft.com/en-us/dax/calendar-function-dax

Then try totalytd

https://docs.microsoft.com/en-us/dax/totalytd-function-dax

Use period end date in the given formula

```Totalytd year = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),'Date'[Date Filer],"3/31"))

Totalytd Last year = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),dateadd('Date'[Date Filer],-1,YEAR),"3/31"))```

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

1 REPLY 1
Highlighted
Super Contributor

Re: Fiscal Year for Previous Year

First of all, create a calendar table

https://docs.microsoft.com/en-us/dax/calendar-function-dax

Then try totalytd

https://docs.microsoft.com/en-us/dax/totalytd-function-dax

Use period end date in the given formula

```Totalytd year = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),'Date'[Date Filer],"3/31"))

Totalytd Last year = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),dateadd('Date'[Date Filer],-1,YEAR),"3/31"))```

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

Helpful resources

Announcements

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)