Calculate function & wild cards

[KimC2504]

Hi there,

Is it possible to use wild cards with the calculate function. I have been trying to do the following without success:

=CALCULATE([New Bus],'SFDC'[Last Week Status]="Upside&"*"")

I want to calculate the value of All upside rows in the last week status column as per below. I could use a helper column but was seeing if I could resolve it with a formula first.

Last week status:

Upside-Sep-57

Upside-Aug-0

Lost-Aug-450

Commit-Aug-16

Upside-Aug-18

Upside-Aug-6

Upside-Aug-0

<colgroup><col></colgroup><tbody>
</tbody>

Thanks for looking

 

[CastroTheCat]

Definitely not a BI expert, but try:

=CALCULATE([New Bus],'SFDC'[Last Week Status]="Upside*")