Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
-I am trying to create a measure that calculates an opening balance for each month.
-The month periods differ i.e. not all months are 1st to 30/31st
-I have a date table where the month periods are defined eg January is 25 Dec to 23 Jan, Feb is 24 Jan to 22 Feb
- The fact table is joined via the "PeriodNoSK" dimension:
- the opening balance would thus be all rows with PeriodNoSK up till the PeriodNoSK -1 per the DateTable
Can anybody help met please?
@Anonymous , Can you share sample data and sample output in table format?
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
@Anonymous , Can you share sample data and sample output in table format? Seem like need write some code 😀
definetely need code 🙂
I cant share my data, but I have given an example I did in Excel in the thread above - can you work from this?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |