Forum Discussion
Power BI Calculation
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 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