Forum Discussion

Cavring's avatar
Cavring
Icon for Helper I rankHelper I
9 years ago
Solved

Need help to shape data and how to approach data set

Hi I have juste started learning Power BI and I would like to analyze my running race data. I have played around with may data, but I'm not getting my head around this.   Background: Each race d...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Cavring,

    You'd better create a new table unioning the required columns form tables using the formula below.

    Table = UNION(SELECTCOLUMNS('1610 Amsterdam maraton',"Løps ID",'1610 Amsterdam maraton'[Løps ID],"Split",'1610 Amsterdam maraton'[Split],"Tid",'1610 Amsterdam maraton'[Tid]),SELECTCOLUMNS('ManuellKorr',"Løps ID",'ManuellKorr'[Løps ID],"Split",'ManuellKorr'[Split],"Tid",'ManuellKorr'[Tid]))




    Then create a measure and table shown in screenshot2.

    Sum Tid1 = sum('Table'[Tid])




    Please download the file form here.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Cavring,

You'd better create a new table unioning the required columns form tables using the formula below.

Table = UNION(SELECTCOLUMNS('1610 Amsterdam maraton',"Løps ID",'1610 Amsterdam maraton'[Løps ID],"Split",'1610 Amsterdam maraton'[Split],"Tid",'1610 Amsterdam maraton'[Tid]),SELECTCOLUMNS('ManuellKorr',"Løps ID",'ManuellKorr'[Løps ID],"Split",'ManuellKorr'[Split],"Tid",'ManuellKorr'[Tid]))




Then create a measure and table shown in screenshot2.

Sum Tid1 = sum('Table'[Tid])




Please download the file form here.

Best Regards,
Angelia

Cavring's avatar
Cavring
Icon for Helper I rankHelper I
9 years ago

Hi @v-huizhn-

It worked like a charm. Thank you very much. I will be getting much use from that.

 

Thanks again,

Espen