Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
how can I grieve only the date on yellow by YTD-1
Thank you.
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.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |