The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 Release Date = IF(IM_ItemWarehouse[Warehouse Code] = "QC",DATEADD(IM_ItemCost[ReceiptDate],17,DAY),"")"
I bascially need to say that if an item is in a specific warehouse, then add 17 days to the "Receipt Date" else Null.
Can someone help me with thisp please?
Thank you!
Try using BLANK() instead of "".
You are trying to return a number under one condition and text under the other condition.
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."
Perhaps try:
QC Release Date = IF(IM_ItemWarehouse[Warehouse Code] = "QC",DATEADD(IM_ItemCost[ReceiptDate].[Date],17,DAY),BLANK())