CLIENTS: Talcum Death SOL using Spreadsheet's wrongful death data, AWKO, Bay, Entrekin

[jesusitd]

Enabled SharePoint Source for SOL SOL MASTER.xlsx., also Dataflow source of Sol table using this PQ code:

let
    Source = PowerBI.Dataflows(null),
    #"5b6ed890-8be2-420f-908c-bc78585cd40d" = Source{[workspaceId="5b6ed890-8be2-420f-908c-bc78585cd40d"]}[Data],
    #"8286f25d-cf54-4088-b4e6-0fce9dc74d53" = #"5b6ed890-8be2-420f-908c-bc78585cd40d"{[dataflowId="8286f25d-cf54-4088-b4e6-0fce9dc74d53"]}[Data],
    Sol = #"8286f25d-cf54-4088-b4e6-0fce9dc74d53"{[entity="Sol"]}[Data]
in
    Sol

Cannot Import into Clients Dataflow (SharePoint source not supported).

Importing into specific Clients datasets:

• DONE AWKO
• Bay Advocacy
• Entrekin
• Rosen Injury

[jesusitd]

New layout for Deceased section:

Power Query calculated columns:

• Injured Party Deceased Date
• Injured Party Deceased State
• Wrongful Death SOL Years
• Death SOL Blown

DONE for:

• AWKO
• Bay Advocacy

[jesusitd]

Closed. Ongoing requirement as needed.