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 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!
Rolling sum for consecutive rows in dax
Hello, I am looking for a dax code to find rolling sum of consecutives rows of a column. So if I have a column as given below: Freight Rs. 89.46 Rs. 85.00 Rs. 85.00 Rs. 17.48 Rs. 85.00 Rs. 89.46 Rs. 89.46 Rs. 84.37 I need the rolling sum column as below: 89.46 174.46 259.46 276.94 361.94 451.4 540.86 625.23 I have been able to achieve it in Excel but not in Dax. Thanks in advance. Sunny