cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Re: Previous Fiscal YTD DAX Not working

@amitchandak : I can not create, [Sales].Date, becasue my date is NOT in hierarchy

I am using posting date, which is not in hierarchy. 

 

Date.png

 

Can you help me to understand how date column is  convert into hierarchy. Then only I can apply  your suggestion above

Highlighted
Resolver I
Resolver I

Re: Previous Fiscal YTD DAX Not working

@amitchandak [Sales].date is not working. I have the sample data snapshot.Data_Snapshot.png 

Below DAX I used:  

Measure_1 = CALCULATE(SUM('Sales_Table'[Sales]),DATESYTD('Date'[Date],"8/31"))
Measure_2 = CALCULATE([Measure_1],SAMEPERIODLASTYEAR('Date'[Date]))
Output is SUM of full fiscal years, 01/Sept/2018 - 31/Aug/2019 , 01/Sept/2017 - 31/Aug/2018, and so on for previous years
 
If you need data in excel, How Can I share via this forum.
 
 
 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors