UnPivot columns in Microsoft Power BI and your data may stop adding up

Unpivot Columns In Power BI, Unpivot Columns transforms columns into rows with attributes and values. In other words, it changes the data structure and as a result it can change values in a visualization. Other ColumnsApplesOrangesBananas12344212 In the table above, we can sum the values in any of the columns. For example, The sum of the column named Other Columns is 5. Other ColumnRead More…

Convert Time Zones

Convert Time Zones in Power BI Reports in 5 Steps or Less

Importing data into Power BI from a data source, like SharePoint, can result in some odd behavior. Date and time values often appear in UTC time instead of the local time zone. Easily convert the time zone with a custom column: Make sure Date/Time/Zone is the data type for your current column. If it isn’t, use the transform tab to change the data type.In Edit Queries, click the Add ColumRead More…