Forum Discussion

MBRocha's avatar
MBRocha
Regular Visitor
3 years ago
Solved

Measure table

Hi i need some help relating a table that is build with measures and the date table. So, in my report i have information regarding kpis that are imported from excel in the format   date         k...
Need Help
  • davehus's avatar
    davehus
    3 years ago

    Hi MBRocha ,

    See if the attached solution will help you. In powequery you can unpivot to KPIs to normalize the data and this will allow you to join on the date. If you need more help, let me know.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

MBRocha's avatar
MBRocha
Regular Visitor
3 years ago

Wonderful, many thanks 🙂

I had only to do one step more (duplicate the data table) and unpivot the new table, in order to don't lose the previous measures and visuals that were built with the data in a different organization (not unpivot).