I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.
One of the most exciting things about being a Power BI service administrator is watching what's going on inside the service. This blog starts a series of articles on how to create your own Service Monitoring application using Power BI.
A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division