In Time period I have the following Year, Quarter, Month, and Day (2018 / Qtr. 1 / Jan / 01/01/2018).
In Measures I have the following:
I want to make the beginning balance a formula that is equal to the ending balance for the prior period (day, month, or quarter). For example, if I am looking at 01/02/18, I want the beginning balance to equal 01/01/18.