Forum Discussion

wolfgang87's avatar
wolfgang87
New Member
1 year ago
Solved

Connecting column headers to row information.

Hello everyone,  I've two tables like below, where the on is an fact table with data from measuring with sensors and the second table is a dimension table with informations to the sensors. Imagine, ...
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    Hello wolfgang87 ,

    You need to unpivot fact table first of all and the table shoud be like this column: Datetime, Attributes(shoud be m1,m2,m3) and values(should be m values). And make relationship between fact and dimension(id to atribute(1 to many)). And create a measure gives average which is AVERAGE(table[Values]).

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi all,thanks for the quick reply, I'll add more.

Hi wolfgang87 ,

Please follow these steps:

1.Unpivot your fact table in Power Query.

2.Establishing relationships between tables

3.Final output

 

Best Regards,
Wenbin Zhou