Power BI Calculation

[CS12345]

Guys.

Sorry for asking. I have a Data which is total production by month and i which to do it total production by month - the NCR of the month.

Anyone know wat formula should i key in in New Measure?

Thanks

[CS12345]

Hi @Gayatri_D05 

Let give a example, I have a monthly total production number of 315 in feb and my ncr for feb is 1 case.

Thus 315-1= 314.

I wanted the formula total prodcution - total of ncr in the month.

Thanks

[Gayatri_D05]

Hi @CS12345 ,
I didnt get you question, Could you please elaborate a bit.

[CS12345]

I had try to key in the formula.

Unfortunately it pop out this

[Anonymous · Accepted solution]

Hi @CS12345,

It seems like your field are text value which cannot be processed by aggregation functions. I'd like to suggest you convert them to numeric value before you calculate on it.

If you not so clarify how to handle this, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng