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?
You can import the data and write that simple SQL code in the Query Editor. After you do that, they will only see that data and can do all the other filtering and data handling from the PBI interface.