Forum Discussion
Filling the blanks
5 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523lbendlin done
Material Description Q1 Q2 Q3 Q4 Material Description Q1 Q2 Q3 Q4 a 212571 247000 247000 a 212571 212571 247000 247000 b 250384 250384 b 250384 250384 250384 250384 c 240127 247000 292525 247000 c 240127 247000 292525 247000 d 242331 250384 139371 250384 d 242331 250384 139371 250384 e 283901 292525 140579 292525 e 283901 292525 140579 292525 f 126518 139371 160115 139371 f 126518 139371 160115 139371 g 127708 140579 158504 140579 g 127708 140579 158504 140579 h 145742 160115 185593 160115 h 145742 160115 185593 160115 i 144094 158504 236795 158504 i 144094 158504 236795 158504 j 168080 185593 233664 185593 j 168080 185593 233664 185593 k 79062 236795 236795 k 79062 236795 236795 236795 l 79593 233664 233664 l 79593 233664 233664 233664 m 91433 m 91433 91433 91433 91433 n 89203 247000 n 89203 247000 247000 247000 o 103964 250384 o 103964 250384 250384 250384 p 218548 292525 247000 p 218548 292525 247000 247000 q 219932 139371 250384 247000 q 219932 139371 250384 247000 r 250845 140579 292525 250384 r 250845 140579 292525 250384 s 247769 160115 139371 292525 s 247769 160115 139371 292525 T 288833 158504 140579 139371 T 288833 158504 140579 139371 u 221162 185593 160115 140579 u 221162 185593 160115 140579 v 222700 236795 158504 160115 v 222700 236795 158504 160115 w 247000 233664 185593 158504 w 247000 233664 185593 158504 x 250384 233664 236795 185593 x 250384 233664 236795 185593 y 233664 236795 y 233664 233664 233664 236795 aa 233664 aa 233664 233664 233664 233664 ab 247000 ab 247000 247000 247000 247000 ac 160115 247000 250384 ac 160115 247000 247000 250384 ad 158504 250384 247000 292525 ad 158504 250384 247000 292525 ae 185593 292525 250384 139371 ae 185593 292525 250384 139371 af 236795 139371 292525 140579 af 236795 139371 292525 140579 ag 233664 140579 139371 160115 ag 233664 140579 139371 160115 Total 5276170 5392579 5018336 5816415 Total 6240882 6661295 6805276 6652232
