Thursday, April 27, 2023

Power BI Filter Table using a CSV Parameter

In Power BI you can filter a table using multiple values using the Text.Split and List.Contains Power Query functions.

Step 1.  Create a Parameter in Power BI and add the values separated by a comma (,)

Example: CSVList with value 1,2,3,4

Power Query - Filter table using CSV Parameter


Step 2: Add a filter to your table using the "Text.Split" and "List.Contains" Power Query function

Thursday, April 13, 2023

Car Emergency Kit

Flat Tire

  • Tire pressure gauge to check your tire pressure. Amazon link
  • 4 way lug wrench to change tire Harbor Freight
  • Car Jack to lift car
  • Tire repair kit with 4 way Valve tool to repair the tire if possible.  Amazon link
  • Spare Tire
  • 12 volt air compressor Harbor Freight

Towing/Recovery

Repair

Emergency

  • Fire extinguisher Amazon
  • First Aid kit
  • Emergency poncho x 2
  • Emergency meal x 2
  • Matches, ferro rod, and lighter
  • Water filter
  • Water bottle
  • Tarp
  • Blanket
  • Umbrella
  • Rain suit
  • Toilet paper
  • Antibacterial wipes
  • Get Home Bag