Forum Discussion
DAX GUI
That is an increadable broad statment and im not sure you have actually asked a question.
DAX is only a very small part of Power bi and is used for writing measures and creating calculated colunms.
what i will say is that in most cases codeing is still needed but Power bi does take away most of the hurt.
for example you can easily select a data source (for example SQL sever) and select tables based on the object model rather than right any sql.
you can then join these tables using the relation ship editor (data model view) in power bi desktop
you can transofrm the data easily in the advanced editor without the need for code by simply right clicking on colunms and making changes such as transfor to UPPER or replace values.
you can also apply filters in many areas such as in the query editor, or in the visuals you create
you can create groups and many others
i would say that a good portion of sql query writing can be avoided by using power BI but it will take some time to learn all the bits and peaces. compared to other alternatives the learning curve is pretty low as power bi is quite intuative i find.
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 ZhiIf 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'
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.
