Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Return the date

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)


Need Help
Show and Tell

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.