Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to create a measure to calculate opening month balance in addition to built-in functions OPENINGBALANCEMONTH AND OPENINGBALANCEQUARTER, using below expression but getting blank row.
Opening balance for start of month
BalanceSOM = CALCULATE( SUM(Balances[Balance]), STARTOFMONTH( 'Date'[Date] ) )
Opening balance for start of quarter
BalanceSOQ = CALCULATE(SUM(Balances[Balance]),STARTOFQUARTER('Date'[Date]))
SS Below
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |