Dynamic conditional formatting for gauge tile

let
    Source = Excel.Workbook(File.Contents("C:\Users\61431\Desktop\GCC\Green Cloud Consulting Pty Ltd - Profit  Loss All Time.xls"), null, true),
    #"Transposed Data1" = Source{[Name="Transposed Data AU & PNG"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Data1", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", Int64.Type}, {"Consulting Revenue", type number}, {"Cost Recoveries", type number}, {"Interest Income", type number}, {"Other Revenue", type number}, {"Management Fee Income", type number}, {"Consulting Expenses", type number}, {"Contractors", type number}, {"Direct Annual Leave Expense", type number}, {"Direct Superannuation", type number}, {"Direct Wages and Salaries", type number}, {"Discounts Provided", type number}, {"Direct Wages and Salaries - Redundancy", type number}, {"Wage offset to align budget & actuals", type number}, {"Gain/(Loss) on Sale of Assets", type number}, {"JobKeeper", Int64.Type}, {"PAYG Cashboost ATO", Int64.Type}, {"Advertising", type number}, {"Amortisation", type number}, {"Bad Debt Expense", Int64.Type}, {"Annual Leave Expense", type number}, {"Bank Fees", type number}, {"Bookkeeping", type number}, {"Conferences", type number}, {"Consulting & Accounting", type number}, {"Depreciation", type number}, {"Dividend offset account to align actuals vs budget", type number}, {"Donations", Int64.Type}, {"Entertainment", type number}, {"Equipment Expense", type number}, {"Filing Fees", type number}, {"Foreign Currency Gains and Losses", type number}, {"Freight & Courier", type number}, {"FX Gain or Loss", type number}, {"General Expenses", type number}, {"Insurance", type number}, {"Interest Expense", type number}, {"Legal expenses", type number}, {"Light, Power, Heating", type number}, {"Marketing Expenses", type number}, {"Motor Vehicle Expenses", type number}, {"Motor Vehicle Fuel", type number}, {"Office Expenses", type number}, {"Outgoings", type number}, {"Printing & Stationery", type number}, {"Recruitment Costs", type number}, {"Registrations", Int64.Type}, {"Rent", type number}, {"Repairs and Maintenance", type number}, {"Subscriptions", type number}, {"Superannuation", type number}, {"Telephone & Internet", type number}, {"Training", type number}, {"Travel - International", Int64.Type}, {"Travel - National", type number}, {"Uniforms", type number}, {"Website Expenses", type number}, {"Dividend Paid", type number}, {"Income Tax Expense", type number}, {"Total Income", type number}, {"Cost of Sales", type number}, {"Gross Profit", type number}, {"Total Other Income", type number}, {"Total Operating Expenses", type number}, {"Operating Profit", type number}, {"Total Non-Operating Expenses", type number}, {"Ner Profit", type number}, {"Number of employees at EOM", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Ner Profit", "Net Profit"}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}, {"Consulting Revenue", type number}, {"Cost Recoveries", type number}, {"Interest Income", type number}, {"Other Revenue", type number}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type1", "Date", "Date - Copy"),
    #"Renamed Columns1" = Table.RenameColumns(#"Duplicated Column",{{"Date - Copy", "Month"}}),
    #"Extracted Month Name" = Table.TransformColumns(#"Renamed Columns1", {{"Month", each Date.MonthName(_), type text}}),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Extracted Month Name", "Date", "Date - Copy"),
    #"Renamed Columns2" = Table.RenameColumns(#"Duplicated Column1",{{"Date - Copy", "Calendar Month"}}),
    #"Extracted Month" = Table.TransformColumns(#"Renamed Columns2",{{"Calendar Month", Date.Month, Int64.Type}}),
    #"Duplicated Column2" = Table.DuplicateColumn(#"Extracted Month", "Calendar Month", "Calendar Month - Copy"),
    #"Renamed Columns3" = Table.RenameColumns(#"Duplicated Column2",{{"Calendar Month - Copy", "Financial Period"}}),
    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns3",{"Financial Period"}),
    #"Added Conditional Column" = Table.AddColumn(#"Removed Columns", "Financial Period", each if [Calendar Month] = 7 then 1 else if [Calendar Month] = 8 then 2 else if [Calendar Month] = 9 then 3 else if [Calendar Month] = 10 then 4 else if [Calendar Month] = 11 then 5 else if [Calendar Month] = 12 then 6 else if [Calendar Month] = 1 then 7 else if [Calendar Month] = 2 then 8 else if [Calendar Month] = 3 then 9 else if [Calendar Month] = 4 then 10 else if [Calendar Month] = 5 then 11 else if [Calendar Month] = 6 then 12 else 0),
    #"Renamed Columns4" = Table.RenameColumns(#"Added Conditional Column",{{"Calendar Month", "Calendar Month"}, {"Month", "Month"}, {"Financial Period", "Financial Period"}}),
    #"Duplicated Column3" = Table.DuplicateColumn(#"Renamed Columns4", "Date", "Date - Copy"),
    #"Extracted Year" = Table.TransformColumns(#"Duplicated Column3",{{"Date - Copy", Date.Year, Int64.Type}}),
    #"Renamed Columns5" = Table.RenameColumns(#"Extracted Year",{{"Date - Copy", "Year"}}),
    #"Added Conditional Column1" = Table.AddColumn(#"Renamed Columns5", "Financial Quarter", each if [Financial Period] <= 3 then "Q1" else if [Financial Period] >= 10 then "Q4" else if [Financial Period] = 4 then "Q2" else if [Financial Period] = 5 then "Q2" else if [Financial Period] = 6 then "Q2" else if [Financial Period] = 7 then "Q3" else if [Financial Period] = 8 then "Q3" else if [Financial Period] = 9 then "Q3" else null),
    #"Added Custom" = Table.AddColumn(#"Added Conditional Column1", "Custom", each [Financial Quarter] & [Year]),
    #"Removed Columns1" = Table.RemoveColumns(#"Added Custom",{"Custom"}),
    #"Added Custom1" = Table.AddColumn(#"Removed Columns1", "Financial Year", each Date.Year(Date.AddDays([Date],184))),
    #"Renamed Columns6" = Table.RenameColumns(#"Added Custom1",{{"Date", "EOM Date"}}),
    #"Duplicated Column4" = Table.DuplicateColumn(#"Renamed Columns6", "EOM Date", "EOM Date - Copy"),
    #"Renamed Columns7" = Table.RenameColumns(#"Duplicated Column4",{{"EOM Date - Copy", "Date"}}),
    #"Inserted Start of Month" = Table.AddColumn(#"Renamed Columns7", "Start of Month", each Date.StartOfMonth([Date]), type date),
    #"Removed Columns2" = Table.RemoveColumns(#"Inserted Start of Month",{"Date"}),
    #"Renamed Columns8" = Table.RenameColumns(#"Removed Columns2",{{"Start of Month", "Date"}}),
    #"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns8",{"Calendar Month", "EOM Date", "Month", "Year", "Financial Period", "Financial Quarter", "Financial Year"}),
    #"Renamed Columns9" = Table.RenameColumns(#"Removed Columns3",{{"   Accrued Expenses - PJM GoPNG", "Accrued Expenses - PJM GoPNG"}})
in
    #"Renamed Columns9"