Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Formula Help

Hello,   I'm having problems getting an expression to work as I am getting the "Expressions that yield variant data-type cannot be used to define calculated columns".   This is what I entered "QC...
General Comments
Linguistic Quality
Terminology
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Try using BLANK() instead of "".

 

You are trying to return a number under one condition and text under the other condition.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Now I am getting a different error.

    "Function 'DATEADD' expects a contiguous selection when the date column is not unique, has gaps or it contains time portion."

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      Perhaps try:

       

      QC Release Date = IF(IM_ItemWarehouse[Warehouse Code] = "QC",DATEADD(IM_ItemCost[ReceiptDate].[Date],17,DAY),BLANK())