2 fabulous new updates again in the April update of Power BI Desktop. Here is my quick review so you can see how great these things are.
Quick measures are designed to help you get started with DAX, without knowing any DAX! OMG I will be out of a job!!
Once again this is a preview feature, so you need to turn it on. Go into File\Options and Settings\Settings and turn it on as shown below.
After restarting, you can now right click on any column in the fields list on the right (shown as 1) and select quick measures (shown as 2).
From there you can select the calculation type you want on the left.
I selected Year to Date (shown as 1) of the SalesAmount Column (shown as 2). There was a date field box that I figured I needed to drag my Calendar[Date] field to as shown in 3.
And BINGO, the following MEASURE was written for me.
When I added the Date column to a Table, it just worked
Note, I have not written any DAX here – the UI wrote it for me. This is an incredible advancement. And what is really important is that I can also edit the DAX if I want to modify it. This is a BIG DEAL.
There are lots of quick measures already and I am sure there will be a lot more to come.
Add Column by Example
This is the other SUPER advancement this month. Miguel has already done a great job of explaining this new feature so I am not going to reinvent the wheel. Spoiler alert: You can add a new column and make the change that you want on a couple of rows, showing Power Query what you want to do – and it will do it for you!!
Just watch the video here.
If you want a comprehensive lesson on how to use Power Query, checkout my training course here https://exceleratorbi.com.au/product/power-query-excel-power-bi-online-training/