Formula help

[texasalynn]

This seems like it should be an easy solution, but my brain is having a freeze. I have a dataset that only allows me to create measures. I need a DAX that would let me create a revenue field if the customer name begins with I/C. Any suggestions?

 

[citizenbh]

If I understand, try this:

Sum Revnue I/C = CALCULATE (SUM[Revnue], LEFT(Table1[Customer Name],3 )= “I/C” )

 

[citizenbh]

Method 2
- Create a new column

[IC group]= IF (LEFT (Table1 [Customer Name], 3) = "I / C", "IC_Group", Table1 [Customer Name])

- From PowerPivot, create a Pivot Table with the following fields

• Rows: [IC Group]
• Σ Values: Sum of Revnue

Row Labels	Sum of Revnue
Abcert	20
cba4546	12
dvg123	26
ghjklmn	75
IC_Group	290
Grand Total	423

<colgroup><col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> </colgroup><tbody>
</tbody>

 

[citizenbh]

You are welcome!