Forum Discussion

BI-Bola's avatar
BI-Bola
Frequent Visitor
7 years ago
Solved

Union based on filter

Hi,   I have a table I've created using the union filter however I would like the function to only create a table with the rows where the date is greater than a say 31/12/2018. Both tables contain ...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi BI-Bola 

     

    You just need an extra step 

    New Table = 
CALCULATETABLE(
    DISTINCT (
        UNION (
            DISTINCT ( 'Table 1'[Account Number] ),
            DISTINCT ( 'Table 2'[Account Number] )
        )
    ),
    'Calendar'[Date] > DATE(2018, 12, 31)
)

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi BI-Bola 

 

You just need an extra step 

New Table = 
CALCULATETABLE(
    DISTINCT (
        UNION (
            DISTINCT ( 'Table 1'[Account Number] ),
            DISTINCT ( 'Table 2'[Account Number] )
        )
    ),
    'Calendar'[Date] > DATE(2018, 12, 31)
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • BI-Bola's avatar
    BI-Bola
    Frequent Visitor
    7 years ago
    Mariusz wrote:

    Hi BI-Bola 

     

    You just need an extra step 

    New Table = 
CALCULATETABLE(
    DISTINCT (
        UNION (
            DISTINCT ( 'Table 1'[Account Number] ),
            DISTINCT ( 'Table 2'[Account Number] )
        )
    ),
    'Calendar'[Date] > DATE(2018, 12, 31)
)

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    Thank you!