Forum Discussion

Nandor's avatar
Nandor
Icon for Helper I rankHelper I
10 years ago
Solved

Split one raw in several rows based on a condition

Hi,   I need oprepare charts to evaluate the up time and down time of the machine.   The operator has a tablet and logs the type of activity.   The data looks like this:   Activity_Type_Al...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    Nandor

     

    There is no function can split one row to several rows with DAX. The only method I can think out is first create several calculated columns for different time period, then create several calculated tables and union them at last. Please refer to following screenshot as below.

    I’ve also upload my .pbix file here for reference. This method is complex and you can take a look at it.

     

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Nandor

 

There is no function can split one row to several rows with DAX. The only method I can think out is first create several calculated columns for different time period, then create several calculated tables and union them at last. Please refer to following screenshot as below.

I’ve also upload my .pbix file here for reference. This method is complex and you can take a look at it.

 

 

Best Regards,

Herbert

Nandor's avatar
Nandor
Icon for Helper I rankHelper I
9 years ago

Thank you, I will explore this aproach.

 

Best regards,

Nandor