Measure table

[MBRocha]

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         kpi1 kpi2 kpi3
01/04/22   2     5      5
06/04/22   4     7     8
09/04/22   9     7     1

I've already calculated several measures to each kpis like count, sum, % of particular data (more than, less than, etc) and already have a relation between this info and the Date table (I'm using fiscal year table).

Now I need to do a visual like this

where in each column is presented different measures to each kpi.

the only way I was able to do so is by creating a new table using de calculated measures like

UNIOn (

ROW ("Name kpis", "kpi1", "measure 1", [measure 1], " "measure 1", [measure 1]) .....

but I'm not able to relate this table with the date so, although the visual is working is not possible to filter 😞

Can you help me?

thanks 

Melanie

[MBRocha]

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).

[davehus · Accepted solution]

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.