Forum Discussion

Josef's avatar
Josef
Icon for Helper I rankHelper I
6 years ago
Solved

Data model from flat SCV file in Power BI Desktop

Hi guys,    I'm still fairly new to Power BI and I run into a problem that I cannot solve by myself. Also not after doing a lot of research on the internet.    It concerns this situation: I creat...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Josef ,

     

    You can follow these steps in the power query editor:

    1.Select the date column and unpivot other columns

    2.Split the column by "-"

     

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

  • Josef's avatar
    Josef
    6 years ago

    V-lianl-msft & amitchandak many thanks for your reply! I'm tried the unpivod option, but this didn't get the desired result for me.

     

    I not sure if it is the most efficient way, but I did the following what solved the issue for me:

     

    I copied the table two times. In the first copy I only kept the columns of device 1 and in the second only for device 2. Then 1 added a custom column 'deviceId' to both tables, for device 1 I put '1' in the custom column and for device two '2'. 

     

    Then I merge the two tables with Compbine > Append Queries as New, to create a new table where all the device data has the same columns, and the data from each device is distinguishable from each other by the deviceId. 

     

    For me the issue is now solved. Again many thanks for your replies!