cancel
Showing results for
Did you mean:
Helper III

Help dax

Hello,

how can I grieve only the date on yellow by YTD-1

Thank you.

4 REPLIES 4
Super User

Hi:

I don't see your table name, what you want to calculate, etc,, But you can try to do the following to obtain a YTD result.

Develope Calc Cols in Table YEAR = YEAR[Response date])

Month No. = MONTH([Response Date])
Month = FORMAT([Response date], "MMM")

YTD X =
var curryear = MAX(Table[Year])
var currdate = MAX(Table[Response date])
return
Calculate(
[X],
Table[Response date] <= currdate,
Table[Year] = currYear,
ALL(Table[Month}),
ALL(Table[Month No]))

YTD LY = CALCULATE([YTD X], SAMEPERIODLASTYEAR(Dates[Date]))  * Need qualified date table. If you have this than YTD can simply be:

YTD X = CALCULATE({X],
DATESYTD(Dates'Date])   or change first year variable above to var Lyear = MAX(Table[Year])-1

I hope this helps.

Helper III

I want just display "YTD N-1" in the column has the place of the date which is in yellow (2021)

Community Support

Hi @Nihed ,

Col = IF(Year('Table'[Response Date]) = 2021,"YTD N-1",'Table'[Response Date])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

Hi:

Can you try this.

Replace = IF(Dates[Date] <= DATE(2021,12,31), SUBSTITUTE(Dates[Date], Dates[Date], "LYYTD"))

Announcements

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

Power BI March 2023 Update

Find out more about the March 2023 update.

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors