Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We get one sum for hole month, on first day of month
and we have to divide this sum on working days number
in my case 126500 is full sum for this month
in august are 23 working days
so I have to divide 126500 to 23 (5500)
and insert 5500 in each rows in column R, so total row will be 126500
http://prntscr.com/g96vua
Please, help me in this task
Solved! Go to Solution.
A calculated column might be better.
Column = VAR y = YEAR ( Table1[Date] ) VAR m = MONTH ( Table1[Date] ) RETURN IF ( Table1[IsWorkingDay] = 1, DIVIDE ( LOOKUPVALUE ( Table1[Amount], Table1[Date], DATE ( y, m, 1 ) ), COUNTROWS ( FILTER ( Table1, YEAR ( Table1[Date] ) = y && MONTH ( Table1[Date] ) = m && Table1[IsWorkingDay] = 1 ) ) ) )
A calculated column might be better.
Column = VAR y = YEAR ( Table1[Date] ) VAR m = MONTH ( Table1[Date] ) RETURN IF ( Table1[IsWorkingDay] = 1, DIVIDE ( LOOKUPVALUE ( Table1[Amount], Table1[Date], DATE ( y, m, 1 ) ), COUNTROWS ( FILTER ( Table1, YEAR ( Table1[Date] ) = y && MONTH ( Table1[Date] ) = m && Table1[IsWorkingDay] = 1 ) ) ) )
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |