Merge Visuals Containing Different Currencies

Hi Anonymous 

 

This is why dimension tables are essential. Directly linking two fact tables isn't ideal because they often have different columns or column values. Instead, create a table that combines the currencies from both tables, then establish one-to-many relationships between this new table and the fact tables.

 

Sample Calculated table

CurrencyTable =
-- Step 1: Create a table containing only the 'Currency' column from Table1
VAR Tbl1 =
    SELECTCOLUMNS (
        Table1,
        -- Source table
        "Currency", -- Column name in the result
        Table1[Currency] -- Column to extract
    ) -- Step 2: Create a table containing only the 'Currency' column from Table2
VAR Tbl2 =
    SELECTCOLUMNS (
        Table2,
        -- Source table
        "Currency", -- Column name in the result
        Table2[Currency] -- Column to extract
    ) -- Step 3: Combine Tbl1 and Tbl2, remove duplicates, and return the result
RETURN
    DISTINCT ( UNION ( Tbl1, -- First table
            Tbl2 -- Second table
            ) )