Forum Discussion
Solved
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 ...
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