TRICKY - Custom Column in Power Query

[Anonymous]

Hi Experts

Kindly refer to excel file and the two columns highlighted in Blue, I am trying to re-create these two column in Power Query. See attached sample data files Excel and PBIX. i have re-created the formula in Excel, which are required in Power BI.

Excel

https://www.dropbox.com/scl/fi/tn548lsxa7ikinqnjypry/Book1.xlsx?dl=0&rlkey=nn3nxk39d96r4wbkfkfie5fu1 

Power BI

https://www.dropbox.com/s/4b1gvi2mpbouumg/TestSample_.pbix?dl=0 

[v-xulin-mstf]

Hi @Anonymous,

Sorry, i can not access to the links.

Could you provide public links?

Best Regards,

Link

[Anonymous]

Hi Link

Could you kindly help with - https://community.powerbi.com/t5/Desktop/Previous-Months-Items-based-on-Eomonth/m-p/1771412#M694215

really stuck...

PS.Ill upload the new files once i have re created them

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

I noticed that you mentioned a new post and there will be a dedicated engineer to provide you with a solution.
If the current post is already solved, please make it answered.

Thank you!

Best Regards,

Link

[StefanoGrimaldi]

they fee column only have 1 unique value, its like this? or how you get this? its a manual fee that its allocated etc?

[Anonymous]

the fee column Always has one unique value in for each month of the year same M column M10.