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.
Hi guys/girls,
I am pretty new at powerBI
Can someone help me solve this problem i would like to copy the type and sintie with the same formulierID.
FormulierID | volg_nr | Naam | Type | Date | Sintie |
78 | 1 | joep | regulier | 3-jan | wada |
78 | 2 | jaap | null | 3-jan | null |
78 | 3 | joop | null | 3-jan | null |
83 | 4 | tim | regulier | 6-jan | woll |
84 | 1 | bert | politie | 3-jan | wazaa |
85 | 1 | bowie | regulier | 8-jan | hah |
85 | 2 | aaa | null | 8-jan | null |
This is how it should look like
FormulierID | volg_nr | Naam | Type | Date | Sintie |
78 | 1 | joep | regulier | 3-jan | wada |
78 | 2 | jaap | regulier | 3-jan | wada |
78 | 3 | joop | regulier | 3-jan | wada |
83 | 4 | tim | regulier | 6-jan | woll |
84 | 1 | bert | politie | 3-jan | wazaa |
85 | 1 | bowie | regulier | 8-jan | hah |
85 | 2 | aaa | regulier | 8-jan | hah |
Many thanks!!
Hi @tanako123
Try these calculated columns
I assume null means BLANK
Type New = CALCULATE ( FIRSTNONBLANK ( Table1[Type], 1 ), ALLEXCEPT ( Table1, Table1[FormulierID] ) )
Sintie New = CALCULATE ( FIRSTNONBLANK ( Table1[Sintie], 1 ), ALLEXCEPT ( Table1, Table1[FormulierID] ) )
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |