Values to all customer rows (Filter, earlier, except??)

[propi_]

Hey Community,

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

 

[Kazlik]

That should work

=IF(table1[Bought Car?] = "Yes",table1[Cust_no],BLANK())

 

[propi_]

That should work

=IF(table1[Bought Car?] = "Yes",table1[Cust_no],BLANK())

Sorry, didn't mentioned, that i wanted to write the cust.no to all rows, if the customer bought e.g. a car.
The Idea is to filter all orders if the customer bought a car. The if condition would only bring the car orders.

Greets
Andy

 

[ImkeF]

Try this:
=CALCULATE(MAX([CustNo);FILTER(Table;IF([BoughCar?]<>blank();[CustNo];BLANK())=EARLIER([CustNo])))

 

[propi_]

Try this:
=CALCULATE(MAX([CustNo);FILTER(Table;IF([BoughCar?]<>blank();[CustNo];BLANK())=EARLIER([CustNo])))

Correction:
=CALCULATE(MAX([Cust_no]);FILTER(Tabelle1;IF([Bought Car?]<>blank();[Cust_No];BLANK())=EARLIER([Cust_No])))

The MAX only works with values but not with strings. Is there a Workaround for strings (text)?
Propably not, because of the Calculate()

Anyway works super! Thanks for Help!