Forum Discussion

Krcmajster's avatar
Krcmajster
Helper IV
6 years ago
Solved

Select values based on conditions

So I have 3 tables, one with locations and 2 with sales and dates. My dev didn't created dates tabel, so my question is:   Can you use dax to select columns based on condition, and that would be ve...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Krcmajster ,

     

    If i understand you correctly, you can use UNION() function to create a calculated table which contains table1 and table2 then use vendor as silcer if you want.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

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

shebr's avatar
shebr
Resolver III
6 years ago

Hi Krcmajster 

 

I believe this is possible, can you provide a subset of data so that I can look at a relevant measure? I I need a bit more information about the vendor and sales values and how they are currently stored.

 

Thanks

 

 

  • Krcmajster's avatar
    Krcmajster
    Helper IV
    6 years ago

     

    shebr Best I could do. The tables are not the same and the connection is more complicted but I can solve this if I have solution for this

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Krcmajster ,

       

      If i understand you correctly, you can use UNION() function to create a calculated table which contains table1 and table2 then use vendor as silcer if you want.

       

      Best Regards,

      Jay

       

      Community Support Team _ Jay Wang

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