Resolves #80952 and also fixes arbitrary rearrangements of pivoted columns (dropping, duplicating and reordering). The bug was caused because fields reordering in `ProjectExec` wrapping `PivotExec` ...

If a user is writing question with count ('column3') and group by column1, column2, Metabase allows users to do a pivot table, but when the same thing user tries to do by writing SQL queries, the ...

This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table ...

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...

When you import data from a relational database like SQL Server in Power BI you have the option of entering your own SQL query to use as a starting point: Here’s the M code for a query that does this: ...