Forum Discussion

CMSGuy's avatar
CMSGuy
Icon for Helper III rankHelper III
3 years ago

Help flattening data

I know somehow this data needs a pivot, but I just need some guidance as I do not have much experience with pivoting data.  This is a sample of data coming into a table in our Power BI report.  It ha...
Need Help
PoweredOut's avatar
PoweredOut
Icon for Resolver I rankResolver I
3 years ago

You can use the Matrix visual. Put the date in the columns and the task in the rows, then insidents in values

  • CMSGuy's avatar
    CMSGuy
    Icon for Helper III rankHelper III
    3 years ago

    Yes tried that, but there are two other tables that need to relate to this table.  There is a main Employee Table where the EmpID comes from.  Then a Details table (the one I need to flatten) that is related by the EmpID.  Then I have an Hours Worked table (related by that EmpID and date) and a Ratings table (related by the same Emp ID and date).  When I include hours or ratings, there are way too many columns (hours and ratings for each Task).