Allocating Targets Why? You missed these Gems closingbalancemonth ,closingbalancequarter 07-24-2020 01:17 AM - last edited 11-30-2022 22:34 PM

[amitchandak]

Closing Balance functions are not used too often -closingbalancemonth ,closingbalancequarter, closingbalanceyear.

These can help you analyze data without allocating.

Discover usages of closingbalancemonth ,closingbalancequarter, closingbalanceyear with eomonth and lastnonblankvalue

 

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

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

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

 

Video : https://www.facebook.com/watch/?v=343509629992272

eyJrIjoiMDJhYzdiMGEtMTQxZC00OGRhLWE4NmQtMzQwYjliN2E0MjQxIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9

[paulfink]

Hi @amitchandak,

Saw your youtube video about the Allocating targets.

How did you make the Quarterly target measure?

I am in the process of making a quarterly report but i cant seem to figure out how to make my targets over a quarterly period.

Could you send me the formula for the Quarterly Target please.