SharePoint daylight saving time

I had this problem when using SharePoint as a datasource for my PowerBI report. Each date in my Sharepoint List was entered as the first of each month (01/07/2022), but for some months, when it came through to PowerBI it was showing (30/06/2022).This was due to the Daylight Savings Time.

My approach to this little problem is a bit "Heath Robinson" but it worked for me.

Duplicate the date Column (which should be in a Date/Time/Timezone format) and then Split the new colulmn by a delimiter of +. This gives you two columns, the second of which is either 01 or 00 (you can delete the first column now as it is redundant).

format the second column as an integer which gives you either 0 or 1 (this gives you an offset).

You can then add that offset in a new calculated column to the original date field by using Date.AddDays

boom - newdate which is now correct

Hope this helps!