Forum Discussion
DAX GUI
My company is looking for a no code alternative to SQL. We need a graphical alternative to SQL methods such a SELECT, INNER JOIN, LEFT JOIN, GROUP BY, aggregate functions and case statements. I've ...
Sorry if I was vague. Basically my employer uses data a lot. The crux of our analytics could be summed up with the following SQL example.
SELECT * FROM SALES WHERE PRODUCT = 'SNEED';
They want a no code version of this. Is there way to do this without writing code, in Power BI?
Hi me_cookie,
If you want to filter data without writing where syntax, you could try to use Slicer in powerbi desktop, but this will load all data in desktop instead of only "SNEED". You could refer to Slicers in Power BI for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
has to have WHERE = 'SNEED'