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 dates (which are linked to a main date table if that helps)

 

New Table =
DISTINCT (
    UNION (
        DISTINCT ( 'Table 1'[Account Number] ),
        DISTINCT ( 'Table 2'[Account Number] )
    )
)

 

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.

2 Replies

  • 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!