Forum Discussion

Romani's avatar
Romani
Helper II
2 years ago
Solved

Visual different dates

CUSTOMER_NAME OFFERS_DATE OFFER_ACCEPTANCE_DATE REJECTION_DATE INVEST_DATE SUBMISSION_TO_R SUBMISSION_DATE_TO_C APPROVAL_DATE Client 85 3/27/2023 3/27/2023   1/29/2024 3/28/2023 3/...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Romani ,

     

    Thanks for reaching out us. You can using the feature "Unpivot Other Columns" to make dates in one column.

    For example, select the CUSTOMER_NAME column and unpivot other columns.

    In Desktop, now you can create visuals you need with these columns.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Romani ,

     

    I see, the workaround in my first reply is actually correct, but you can't go into Power Query.

    There's no better way to do that than to get into Power Query. Or you can experiment with some visuals to see if they meet your needs, such as: Decomopisiton tree visual.

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Romani ,

 

Thanks for reaching out us. You can using the feature "Unpivot Other Columns" to make dates in one column.

For example, select the CUSTOMER_NAME column and unpivot other columns.

In Desktop, now you can create visuals you need with these columns.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Romani's avatar
Romani
Helper II
2 years ago

Your idea is more than perfect but the issue is i dont have access to power query edito due too some security layers 

There is a way to achieve the needed output

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Romani ,

     

    Thanks for your response.

    After reviewing your post and understanding that you can't go to Power Query. You can try this alternative workaround.

    You want to see the days between dates, right?

    Please try the DATEDIFF function. You can create measures or calculated columns, either of which. Here I created calculated columns.

    Days acceptance = DATEDIFF([OFFERS_DATE],[OFFER_ACCEPTANCE_DATE],DAY)
    Days between OFFERS and INVEST = DATEDIFF([OFFERS_DATE],'Table'[INVEST_DATE],DAY)

    Then you can try different visuals to show the days. Because the sample data is simple, the visuals may not look particularly good.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Romani's avatar
      Romani
      Helper II
      2 years ago

      No you didnt get my point 
      what i want to visual the client journey throgh different dates 
      so i want something like line chart to told me that the:

      Client 85
      has offer in 3/27/2023
      he accepted the offer in 3/27/2023
      then SUBMISSION_TO_R in 3/28/2023
      then to investigation in 1/29/2024

      so i want visual could help me to achieve that point

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Romani ,

         

        I see, the workaround in my first reply is actually correct, but you can't go into Power Query.

        There's no better way to do that than to get into Power Query. Or you can experiment with some visuals to see if they meet your needs, such as: Decomopisiton tree visual.

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.