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

<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>
[TD="width: 92"]Row Labels[/TD]
[TD="width: 101"]Sum of Revnue[/TD]

[TD="class: xl63"]Abcert[/TD]
[TD="align: right"]20[/TD]

[TD="class: xl63"]cba4546[/TD]
[TD="align: right"]12
[/TD]

[TD="class: xl63"]dvg123[/TD]
[TD="align: right"]26[/TD]

[TD="class: xl63"]ghjklmn[/TD]
[TD="align: right"]75[/TD]

[TD="class: xl63"]IC_Group[/TD]
[TD="align: right"]290[/TD]

[TD="class: xl63"]Grand Total[/TD]
[TD="align: right"]423[/TD]

</tbody>

 

[citizenbh]

You are welcome!