Forum Discussion

paulfink's avatar
paulfink
Icon for Post Patron rankPost Patron
5 years ago
Solved

DAX: New Table that splits time tracking into single lines

Hi guys,   I need a new table that splits the lines of my time tracking table that tracks time of sickness and holiday.   In my time tracking table it is structured as so: Name Type (Holiday o...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi paulfink,

     

    If you want to use Dax, you can try this demo.

    Here is the output:

     

    Best Regard,

    Link 

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Did you have problems running my code? It produces your expected outcome.

paulfink's avatar
paulfink
Icon for Post Patron rankPost Patron
5 years ago

Yes it did work but i do not know how to make it applicable for my data

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi paulfink,

     

    If you want to use Dax, you can try this demo.

    Here is the output:

     

    Best Regard,

    Link 

     

     

    • paulfink's avatar
      paulfink
      Icon for Post Patron rankPost Patron
      5 years ago

      Sorry for the late reply v-xulin-mstf 

       

      the picture of the table you attached is not my desired output.

       

      The Deminsion has to add up to the duration.

       

      So if John B's duration is 3, then he would get 3 seperate lines and in those lines, the dimension would be 1.

       

       

       

      and if the Duration is greater than 1 and also has a 0.5 decimal, it should have an additonal line that is 0.5.

       

       

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi paulfink

         

        I got you, but it is not supported with dax now, the demo I provided is a workaround.

         

        Best Regards,

        Link