Forum Discussion

PranjaliB's avatar
PranjaliB
Frequent Visitor
7 years ago

How to create Select query with where clause with AND condition in Power BI

Hi , I am creating Power BI reports  and Some SQL queries are like this in which @StartDate,@FinishDate,@DepSelection are query parameter   SELECT DISTINCT p.[ProjectUID], p.[Project code] FROM ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi PranjaliB,

 

If you'd like to show the result in a visual, I would suggest you add the two columns in a Table visual and filter them by the Slicers. If you'd like a calculated table, please try dax/selectcolumns-function-dax and dax/filter-functions-dax. Please share a sample. We can write down a complete formula.

 

Best Regards,
Dale