Power BI tutorial for beginners on how to find the value at the last of day of year using the DAX time intelligence function closingbalanceyear that very easily do the work for reporting numbers at the last day of quarter.
https://docs.google.com/spreadsheets/...