Forum Discussion

ggzmorsh's avatar
ggzmorsh
Helper II
6 years ago
Solved

Table from a distinct category

I would like to create a distinct table from Table1   reference.id event.id 1 a 2 b 3 c 4 d 5 e 6 a 7 b 8 c 9 d 10 e 11 a 12 b 13 c 14 d ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi ggzmorsh 

     

    The simplest way with use of New Table DAX expression 

    Table2 = FILTER( Table1, Table1[event.id] = "a" )



    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.



Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi ggzmorsh 

 

The simplest way with use of New Table DAX expression 

Table2 = FILTER( Table1, Table1[event.id] = "a" )



Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.