DAX is supper powerful, if you design your datawarehouse as a proper stat scheme, there is nothing you cannot calculate using DAX
Nothing in the market is even close, most BI tool have magic expression language, DAX is a proper language
Power BI's trending is one thing I have really struggled with the limitations it has.
For one of my use cases (industrial plant data) we often want to trend timeseries data on a common xaxis with uniquely scaled yaxis.
i.e Temperature, Pressure, Flow Rate, Fill height etc all have differently scaled yaxis but common xaxis.
Something like this example https://imgur.com/a/zd5Giom
Power BI limits you to a single primary and a single secondary Y axis only (i.e limit of two scales).
can you put that back, for some reason my browser history lost it , or something weird happened, not sure what it is
I expect how useful it is depends a lot on your use cases. If you want to throw a couple of KPI's on a dashboard it fulfils that requirement pretty well but if you want to do any analytics (beyond basic aggregations like, min, max and median) or slightly complicated trending (like multiple Y axis) Power BI is painfully complicated.