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

 

How about the result if we can categorize each row to “shift1”, “shift1-2”, “shift2”, “shift2-3”, “shift3” and “shift1-3”?

BTW, what do the values in horizontal axis (36.1, 36.2, 37.5) mean?

 

Best Regards,

Herbert

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

It will not help to make mixed shifts because for each shift we a have a head of team who is has bonuses if she reaches a certin procentage of up time.

 

The x axis is the week number and the day ( 36 1 is week 36, 1st of september).