Ficial-DateNo

How to Add a Column with Fiscal Month or Fiscal Week Number Not Starting From Jan 1?

Part I – Fiscal Month Here is a potential solution assuming you have some kind of data table with a column called Value that has your dates in it: Create a “Standard Month” column using MONTH([Value]) For example, create a “Custom Month” column for the Fiscal month starting from April 1: Part II – Fiscal […]

Ficial-DateNo

How to Optimize Performance in Power Query

Occasionally, organizations will need to address performance issues when running reports. Power BI provides the Performance Analyzer tool to help fix problems and streamline the process. Consider the scenario where you are building reports for the Sales team in your organization. You’ve imported your data, which is in several tables within the Sales team’s SQL […]

Ficial-DateNo

How To Convert UTC to Local DateTime in Power BI

Solutions 1: Convert Time Zones – FORMAT Even if your SharePoint site’s regional settings are correct (or whichever data source you’re pulling from), Power BI could convert it to the wrong time zone upon import. It’s a quick fix, luckily. Instead of using your “modified,” “created” or other date fields in your report, we’ll create […]

Ficial-DateNo

How to Export a Table from Power BI Desktop to Excel

There are some ways to export Power BI Desktop data in Excel. You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel. This way is good for a small volume of data.  Go to Date View and select the table you want to export, select Copy Table and then paste it in […]