how to create delta measure on union query

Question

i have created union with measure in different year and want to compare that two years and get a delta column in union when it gets showing on pivot.

product                FY2020               FY2019            Delta

------------------------------------------------------------------------------

Toy                      1650                      1630               ?

Electronics          45000                    54200             ?

any idea?

thanks.!

Joel Acha · Answer

Have you used a result column to calculate the delta?

@Gianni Ceresa

As @Gianni Ceresa mentioned, it may be a better option to federate the data in the repository so that you get all the data from a single logical fact and dimension and therefore, a single analyses without any set operation required.

[Deleted User] · Answer

user2074645 wrote:Yes, I came to a last option ..

What did you try before? Which approaches did you do?

Tony_OAS_Apex_User · Answer

Thanks Gianni,

Yes, I came to a last option ..

yes it's from different models.