Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ) ) ) )