It's difficult to make it completely flexible, but as long as the header rows are always in row 7 on the green tabs and the codes are always in column A, you could use something like this:
=INDEX(SafeDelivery!$A:$R,MATCH($B8,SafeDelivery!$A:$A,0),MATCH(C$7,SafeDelivery!$7:$7,0))
Usually the issue is that you are checking the file by opening it in Excel, at which point Excel will indeed remove the leading zeroes. That does not mean that they are not present in the CSV file! Test that by opening it in Notepad or another text editor, not in Excel.
When Excel saves a file...
The issue is that your two slicers are using date groupings on the ETA field. If you don't input a date, the field is no longer a date field and can't be grouped, so they disappear. You already have a month column in the table and you can add a year column , then use those two for the slicers...
Unfortunately everything Monty wrote was wrong. (that's the problem with blindly using AI to generate your answers)
You do not need to declare your variables as Object. Worksheet is just fine.
Also you cannot refer to a sheet in a different workbook using its codename unless you set a...
I've done the transformation in PQ in your excel workbook. I assume you can replicate it in the PQ editor in Power BI if that's where you need it. It's just an unpivot and then pivot on the Type column.
It appears you do not have an up to date enough version for that formula. It appears to use the ETA SUM function which I think is still only in Insiders Beta.
Your CALCULATE statement calculates one value, so CountX on that returns 1 as it is counting the number of values. The actual value calculated is 3 and the sum of 3 is 3, so that's what sumx returns.
Now cross-posted here: https://forum.ozgrid.com/forum/index.php?thread/1233661-how-to-run-rest-api-in-vba-taking-parameter-from-1-sheet-and-store-response-valu/
Do any of your text descriptions contain a comma? It seems your delimiters are not consistent and fixing that I suspect will be more complicated if it is not ok to just replace commas with pipe symbols.
In your personal.xlsb project in the vb editor, try adding a reference (using Tools - References). It doesn't matter which one you choose. Then Debug - Compile VBA project. Now remove the reference, and compile again and see if the macros appear in the Macros dialog?