Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ) ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |