Nz for Power BI
Nz is a nice and frequently used function from ACCESS. Unfortunately it is for the moment not possible to import queries using this function from ACCESS into Power BI. I hope that this changes one day !
STATUS
DETAILS
New
Dynamic column name references
For the moment it is, as far as I know, not possible to use a field value in order to refer to a column of a table or a measure by using DAX (a workaround consists in using the switch functions, which works well in simple situations). With the DSUM-function one can however compute a sum in ACCESS...
STATUS
DETAILS
New