Forum Discussion
Power BI Calculation
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
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
4 Replies
Hi CS12345 ,
I didnt get you question, Could you please elaborate a bit.I had try to key in the formula.
Unfortunately it pop out this
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
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
