Help with Date Cards please

[Pricey79]

Hello everyone , I was hoping someone could help.

I have a target date column in my query, but I would like to show that as a week number on a visual ( I guess a card?)

How do I do that please?

So for example, Product A is clicked on and the card says Target Date is Week 36

Thank you in advance. 

[Jihwan_Kim · Accepted solution]

Hi, @Pricey79 

please try to create a measure something like the below.

Show TargetDate as WeekNo =

"Week " & WEEKNUM( SELECTEDVALUE('Table'[TargetDate]))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Pricey79]

@Jihwan_Kim Perfect, thank you so much. 

[Pragati11]

Hi @Pricey79 ,

You can use WEEKNUM function to calculate a week against your date column.

Is you target date getting calculated somehow or it is a direct column coming from data?

Link on how to use WEEKNUM function is as follows:
https://docs.microsoft.com/en-us/dax/weeknum-function-dax

Thanks,

Pragati

[Pricey79]

@Pragati11  Thank you for your reply, much appreciated.