Hey Community,
simple Example:
<colgroup><col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:16310;width:335pt" width="446"> <col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> </colgroup><tbody>
</tbody>
How do I get the Cust_no in all rows?
Propably one of these: earlier, allexcept or filter, but can't get it to go.
Wanted syntax wording: value to all rows()
THX and have a nice week!
Andy
simple Example:
Cust_no | Product | Bought Car? | Calculated Column for [Bought Car?] | Calculated Column 2 Wanted result |
1 | Bike | 1 ?? | ||
1 | Car | Yes | 1 =CALCULATE(VALUES(table1[cust_no]);table1[Bought Car?]="Yes" | 1 ?? |
<colgroup><col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:16310;width:335pt" width="446"> <col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> </colgroup><tbody>
</tbody>
How do I get the Cust_no in all rows?
Propably one of these: earlier, allexcept or filter, but can't get it to go.
Wanted syntax wording: value to all rows()
THX and have a nice week!
Andy