Return the date

[Anonymous]

Good Day Everyone..

Is this possible to show the year ? 
the as of is assigned date
Now i have a relation from assigned date and completion date

can i posible show the year from assigned date ?
as you can see below..
their is a request from november(2018) that is only completed by oct. 2019 ..(my user want to see what year it came from)

[Mariusz]

Hi @Anonymous 

You can create a date dimension and build a relationship between your date and date in that dimension and use Year column or Year Month column in your visual 

The below link are examples of date dimensions

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

I already have a date dimension sir,. assigned and completion date have a relation (specially month)
btw. thank you for your feedback

my concern was .
there is assigned request from oct 2018 that was only completed by march .2019
since my slicer is from assigned date..
i cant even show the date (when it was assigned) but if it was assigned by the same year(assigned year)..it shows.

as you can see below..it only shows the month assigned.