cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

How to apply where condition

I have table tets

IDnamefil
1a1
2b2
3c2

 

i would like to get like this Select * from test where fil = 2

name

name
b
c

 

Thanks 

LP

LEa

11 REPLIES 11
Highlighted
Super User II
Super User II

Re: How to apply where condition

@LeaRupnik ,

 

Refer below screen shot.

Capture.JPG

 

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you
Highlighted
Super User II
Super User II

Re: How to apply where condition

@LeaRupnik ,

 

Or You can also create a field like below:

Column=CALCULATE(VALUES(Table1[Name]),Table1[Fill]=2)
 
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
Don't forget to give thumbs up and accept this as a solution if it helped you
Highlighted
Helper II
Helper II

Re: How to apply where condition

This

"Column=CALCULATE(VALUES(Table1[Name]),Table1[Fill]=2)" 

dosent work 

LP

Lea

Highlighted
Helper II
Helper II

Re: How to apply where condition

sorry is work, now i have a quastion about 

How i create 1 new table with some where condition in another table. 

tableTest = SELECTCOLUMNS(ORGANIZACIJA;"PARENT_ID";ORGANIZACIJA[PARENT_ID];"ID";ORGANIZACIJA[ID];"i";1)
 
where condition is from another known table. 
 
thanks
Lea
Highlighted
Super User II
Super User II

Re: How to apply where condition

@LeaRupnik ,

 

That works fine. (Screen shot is attached)

Capture.JPG

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you
Highlighted
Super User II
Super User II

Re: How to apply where condition

@LeaRupnik ,

 

For extracting values from different table use the RELATED function with column name of another table.

 

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you
Highlighted
Helper II
Helper II

Re: How to apply where condition

Jes bat where i have tu incude this. 

I create tem table from another table and i have distinct tihi tam table from jon sam key from another table. 

Table1 = SELECTCOLUMNS(ORGANIZACIJA;"PARENT_ID";ORGANIZACIJA[PARENT_ID];"ID";ORGANIZACIJA[ID];"i";1)

 

Table2 --> PAKIRNAO - KEY  from pakirano is ORG with ORGANIZACIJA with key ORG. 

 

Lp

LEa

Highlighted
Solution Sage
Solution Sage

Re: How to apply where condition

Hi @LeaRupnik ,

I'm a little confused by your description. Do you want results similar to the following:

31.PNG32.PNG

You can use Fiter function and Allexcept function, here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQtYTLC_n5RPoJMr85...

If not your case, kindly share your sample data and expected result if you don't have any Confidential Information. 

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper II
Helper II

Re: How to apply where condition

My problem is laki this  a have table Organization and packing, how a create a new table lake table1.

Organization    packing    table1  
idfirmaorg   nameorg   idfirma org
1121   a31   1121
21A30   b21   21151
31151   a31      
411b2   b11      
      c11      
      s27      
      f51      
      b51      

 

Lp

Lea

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors