Forum Discussion

Dev-001's avatar
Dev-001
Regular Visitor
1 year ago

Expression.Error:We cannot apply operator + to types Date and Number

Hi I keep the above error even after changing data type to Date.Trying to create a new custom column based on another column. This was the excel formula =IF(AND(AM2="M",OR(AL2="",AL2<TOD...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Dev-001 

Use Date.AddDays(Date.From(DateTime.LocalNow()), 1)

 

Note: Power BI Servie uses UTC so take that into consideration when using functions that gets the current time. I use the formula below to convert a UTC date to my current time zone.

Date.From(DateTime.From(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()) + #duration(0,8,0,0)))
//replace +/8 with your UTC offset