Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a balance of accounts for every working day. But there's no balance for the weekend, holliday
08.09.22 200 000
09.09.22 205 000
10.09.22 day off
11.09.22 day off
12.09.22 203 200
This balance for each account
How to copy weekends to correctly calculate the average balance. I have an array of 1 million entries
Thss is code does not work if the balance = 0 for the working day, it is duplicated further, but I don’t need this
There may be such a situation
08.09.22 200 000
09.09.22 205 000
10.09.22 day off
11.09.22 day off
12.09.22 0.00
13.09.22 203 000
should be
08.09.22 200 000
09.09.22 205 000
10.09.22 day off 205 000
11.09.22 day off 205 000
12.09.22 0.00
13.09.22 203 000
It's not just the weekend.
sometimes weekends are working days.
@ViktoriaRv , check if this code can help little bit -https://amitchandak.medium.com/power-bi-show-weekend-data-on-monday-or-friday-dab5ee201f0e
It's not just the weekend.
sometimes weekends are working days.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |