Forum Discussion

Apssawhney's avatar
Apssawhney
New Member
5 years ago

Create a Patch Calendar in PowerBi

Hi PowerBI Gurus,

 

I have a custom calendar in Excel which we use to track the windows patch cycle for our organization. I am looking to create a calendar view in PowerBI where it should automatically highlight dates based on below conditions. 

 

  1. Microsoft Patch 2nd Tuesday (every 2nd week in the month)
    2. Non-prod servers patching Starts on Thursday (after the 2nd Tuesday of the month) at 8 PM PST.
    3. Work stations patching for UAT Machines starts on Friday (after the 2nd Tuesday of the month) at 1 PM CT.
    4. Prod servers patching starts on Friday (after the 3rd Tuesday of the month) at 8 PM PST.
    5. Work stations production patching starts on Friday (after the 3rd Tuesday of the month) at 6 PM CT
    6. Freeze Period (25th Dec-30th Dec)
    7. USA Holidays 

It should look something like this. Please advsie.