Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Nihed
Helper III
Helper III

Help dax

Hello,

 

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

Nihed_0-1648669044522.png

Thank you.

4 REPLIES 4
Whitewater100
Solution Sage
Solution Sage

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.

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

Hi @Nihed ,

 

Please try:

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.

Hi:

Can you try this.

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors