Hi all,
I am writing a DAX formula to return a text result ("NED", which means "not enough data") if a quantity on hand of an item is less than a certain amount. However, if it is true, then it should return the numerical data. I don't care if the data is actually stored as a number or a string, however, as I am just displaying it in a card in Power BI desktop. Though the data IS numerical in previous calculations (hence why this final calculation is called "Calc4_qOH"). Here's my query:
EstQtyOH = IF(InvAnalytics[Calc4_qOH] < 2, "NED", InvAnalytics[Calc4_qOH])
I receive the error "Expressions that yield variant data-type cannot be used to define calculated columns."
If I change "NED" to a number, the IF statement works. I tried SWITCH as well, but didn't get any further than if I used IF. Am I doing something wrong and my request is possible, or is my request impossible for DAX? Again, I am still learning DAX as I go. Many thanks in advance!
- Derek
