Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Assign date and time to values in columns

Hello everyone,    I've been working with power BI around 4 months, and now I'm starting to get more complicated tasks in my work. I have a large dataset with a date column and several values colum...
Need Help
Tutorial Requests
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to unpivot All 'Dxx' columns:

    Then split the [Attribute] column:

    After Apply&Close, please try to create a calculated column:

    Column = FORMAT('Table'[Date]+TIME(0,'Table'[Attribute.2]*30,0),"YYYY-MM-DD HH:MM:SS")

    The result shows:

    Here is my test pbix file:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Please try to unpivot All 'Dxx' columns:

Then split the [Attribute] column:

After Apply&Close, please try to create a calculated column:

Column = FORMAT('Table'[Date]+TIME(0,'Table'[Attribute.2]*30,0),"YYYY-MM-DD HH:MM:SS")

The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'ts perfect! Thank you so much for your help!!