cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
heygau
Frequent Visitor

YTD Current Year and YTD previous Year

 

----Fincial Year strats from July 1st 

 

Books Received for Current Year YTD = 
CALCULATE(([Books Received]),DATESYTD('Date'[Date],"30/06"))

 

Books Received previous Year YTD =

CALCULATE(TOTALYTD([Books Received],'Date'[Date],"30/06"),
DATESYTD(SAMEPERIODLASTYEAR('Date'[Date])),
MONTH('Date'[Date]) < MONTH(TODAY()) || (MONTH('Date'[Date]) = MONTH(TODAY()) && DAY('Date'[Date]) <= DAY(TODAY())))
 
 
  1. The Differnece is not working Properly, Some months shows correct value some months not 
  2. I need to place (Difference value) (Current YTD -Preyr YTD) in Card visual in that Dashboard Page I should not show Date slicers, 




1 ACCEPTED SOLUTION
CNENFRNL
Super User
Super User

 

Books Received for Previous Year YTD =
CALCULATE(
    [Books Received],
    DATEADD( DATESYTD( 'Date'[Date], "30/06" ), -1, YEAR )
)

 


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

1 REPLY 1
CNENFRNL
Super User
Super User

 

Books Received for Previous Year YTD =
CALCULATE(
    [Books Received],
    DATEADD( DATESYTD( 'Date'[Date], "30/06" ), -1, YEAR )
)

 


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors