Last YTD based on last date from data aupload

[conniedevina]

Hi All,

I have an issue regarding Last YTD, I have this sample data

I would like to achieve the total data 2022 till Aug.. because the current year data only available till August 2023.

I understand to use DatesYTD function but when I tried to use with flexible date somehow not working.

Below is the DAX I tried

m_LY FY = CALCULATE(SUM(Value), DATESYTD(dateadd('Date'[Date],-1,Year),FORMAT(MAX(Completions[Training Record Completed Date]),"MM/YY")))

Would appreciate any help provided! Thank you!

[Bibiano_Geraldo]

Try the following code, and see if is what you need

m_LY FY = 
CALCULATE(
    SUM(Value), 
    SAMEPERIODLASTYEAR(
        'Date'[Date]
        )
)

[conniedevina]

Hi @Bibiano_Geraldo 

Thanks for replying, I'm using the calculation but seems it's still showing me "Total all 2022"

While I am trying to achieve total 3774

as reference I put the pbix file here PBI File 

I would like to use "Date" Table to show the dates.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[conniedevina]

Hi @Ashish_Mathur 

Thank you so much for the help, so I should create the "Date" Table following the Transaction table is it?

Thank you for help!

[Ashish_Mathur]

You are welcome.  Yes.