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!

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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
    Icon for Helper I rankHelper I
    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!

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Josef ,

       

      It's glad that you have solved your problem.
      Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

       

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

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hello @Josef,

      I'm glad you solved your problem.
      Please accept the answers that make sense as a solution to your question so that people who may have the same question can get the solution directly.

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