Forum

Hi Caspar, It looks like calculation is for Total America row (Cost/T X Quantity) like below. Total America quantity is 4,835.082625 and av...

Thank you so much Mynda. You are a precious gem!!!!!!!!!!! Kind Regards Arun

Hi Mynda, Data will not be used in Power Pivot or in a Pivot table. Please advise. Kind Regards Arun

Hi Mynda, Basically I need dynamic calculated column (variance between CY and PY) in power query, so if I change period in excel file cell, re...

Hi Mynda, Thanks for your reply. 7.01 is more related to filtering the rows. My issue is to apply parameter in calculated column like current ...

Thank you so much Mynda...