Forum Discussion
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 ...
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??
