Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter with UNION

hello to all,   I created a unique table from 2 tables "BUDGprojects" and "REALprojects" / without duplicates, with the following DAX formula: REF_REEL&BUDGProjects = DISTINCT(UNION(BUDGProjects, ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Try this formula.

     

    Table = DISTINCT(UNION(FILTER(BUDGprojects,LEFT(BUDGprojects[column],1) in { "F","J","G","E"}),FILTER(BUDGprojects,LEFT(BUDGprojects[column],1) in { "F","J","G","E"})))

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Try this formula.

 

Table = DISTINCT(UNION(FILTER(BUDGprojects,LEFT(BUDGprojects[column],1) in { "F","J","G","E"}),FILTER(BUDGprojects,LEFT(BUDGprojects[column],1) in { "F","J","G","E"})))

 

 

Best Regards,

Jay