Need to Show the year(last 2 digits) along with dynamic week number in the report header

[Anupal]

Hello Members,

I need to display the dynamic year,Quarter and week number in the report header

What I have is -

However What I need to show is this-

so Need to know the DAX for shoiwng this above in the report header.

Thanks

AP

[lbendlin]

What do you mean by Report Header?

Anyway, the FORMAT function gives you that flexibility as long as you can clearly define what you mean by Week.

[dharmendars007 · Accepted solution]

Hello @Anupal , 

Please create a Calculated column like the below to get the date formatted like you mentioned..

Date Format = FORMAT('Date Table'[Date], "YY"&"'")&"Q"&'Date Table'[Quarter]&" WK"&'Date Table'[Week]

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN