Forum Discussion

TimK's avatar
TimK
Helper III
3 years ago

Merge Data created in Measures

I have what i find is a challenging issue, which i will explain: I have a number of Measures, which basically sumarise 2 different sets of data, but the tags come from the same source but different ...
Need Help
TimK's avatar
TimK
Helper III
3 years ago

Thanks DataInsights.........

Does not do the job - it does not fill out the blanks.... it returns my third table, but without the Pink text

 

Any other ideas?

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

TimK there are no empty lines in the file you provided, Explain your problem in more detail

  • TimK's avatar
    TimK
    Helper III
    3 years ago

    sorry,

    here is the PBIX file again - FILE

     

    So if you look at the tab [ARM_2] you will see that i have the tags [Project] and [DD]..... however, each [Project] tag does not have both [DD] tags - the L and the M (AA does; BB does not have the M etc)

     

    What i am after is on the tab [Results] is to have for each [Project] the L and M tags

     

    Where there is not a value from [Table 2], it takes the value from the corresponding [Project] in [Table 1]

     

    So it looks like the results in the [Result] tab in Excel

     

    Does that help??