Allocating Targets- Why? You missed these Gems -Part 2 -openingbalancemonth,openingbalancequarter 07-24-2020 06:59 AM - last edited 08-04-2020 08:30 AM

[amitchandak]

Like Closing Balance functions Opening Balance are also, not used too often -openingbalancemonth,openingbalancequarter, openingbalanceyear .

These can help you analyze data without allocating.

Discover usages of openingbalancemonth,openingbalancequarter, openingbalanceyear with parallelperiodand firstnonblankvalue

https://docs.microsoft.com/en-us/dax/openingbalancemonth-function-dax

https://docs.microsoft.com/en-us/dax/openingbalancequarter-function-dax

https://docs.microsoft.com/en-us/dax/openingbalanceyear-function-dax

https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax

eyJrIjoiZDU2NjJlMWQtYzNkNy00MzVlLTkxYmQtN2E4ODYwMzJjMzA0IiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9