Dax, Power Bi, Dateadd, Parallelperiod, Power Bi Tutorials.
CLOSINGBALANCEYEAR, CLOSINGBALANCEQUARTER, CLOSINGBALANCEMONTH These calculate an expression for the last date of the year, quarter, or month. OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR In contrast, these calculate an expression for the first date of the year, quarter, or month.