Forum Discussion

JQuon's avatar
JQuon
Icon for Helper I rankHelper I
7 years ago
Solved

Use WHERE condition in DAX with Union and Selectcolumns?

I've created a calculated table that takes information from 5 different tables and consolidates it into 3 appended columns (Category, Name, Complete Date) on a single table.  The calculated table was...
Need Help
  • JQuon's avatar
    JQuon
    7 years ago

    The outcome in my original formula is working and I do not receive an error message. The entire formula is about 20 lines and in my example in the original post, I only included the first string of the union, which I understand may cause confusion.

     

    Over the weekend I found a solution through additional research on the web and using || for more than one conditions appears to work.  I'm not sure why && doesn't work but || does.  Thanks for looking into this.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi JQuon,

 

Is there an error? Or the outcome isn't correct? 

If the formula is complete, the UNION isn't correct there. Please refer to the snapshot below. 

Can you share a sample if you still have issues?

Use-WHERE-condition-in-DAX-with-Union-and-Selectcolumns

 

Best Regards,
Dale

JQuon's avatar
JQuon
Icon for Helper I rankHelper I
7 years ago

The outcome in my original formula is working and I do not receive an error message. The entire formula is about 20 lines and in my example in the original post, I only included the first string of the union, which I understand may cause confusion.

 

Over the weekend I found a solution through additional research on the web and using || for more than one conditions appears to work.  I'm not sure why && doesn't work but || does.  Thanks for looking into this.