Forum Discussion
Help with Power Query custom column creation - formula error
Hi siddrow ,
I honestly have no idea what this calculation is supposed to achieve, but you can try converting your date into a number within the calculation by putting Number.From( ) around it: Number.From([Date Last Changed])
Pete
If the first condition is met, i want it to calculate [Strategy Years] - [Current Financial Year] - [Date Last Changed] otehrwise if it doesn't i want it to calculate [Strategy Years] - [Current Financial Year] - [FY Final 2]
Not sure how to explain it any other way. This is the excel formula that i've tried to convert it from - not sure if this helps either. I will try your suggestion and see if it changes anything. thank you
=IFERROR(IF(AX$3<=AW19),$AT19-(AX$3+$AU19),$AT19-(AX$3-($AW19))),"")
Hi siddrow ,
Actually, I think seeing that Excel formula does help. The first thing I notice is that your row references are not the same (3 & 19) and that some have fixed ($) references, which means you'll struggle to replicate it unless you've either already transformed your data into matching rows, or you're using separate query references.
If my previous Number.From() suggestion doesn't work for you then, if you can provide an example of the Excel data (screenshot will probably do, including row and column headers) that the Excel formula is working off, and also a copyable example of your Power Query source data, I should be able to put a working solution together for you.
Pete