Time Conversion

This question is very common in Power BI community, Convert Time to Duration or Duration to Time? The answer becomes very simple to resolve once we know that we should start from the Total Seconds in hand. Both of the solution can be done in Power Query as well as using DAX in Power BI Desktop. By images I let you discover them:

Read more

Financial statements Report

To all finance community and here we are into a new fiscal year. Before we start developing and analyzing all financial statements, should we first thank all bookkeepers that worked hard on their ERPs to adjust and close the GL Accounts for the past year….

Read more

Power Bi Import vs Direct Query mode

In my opinion I think the most critical step in developing a report is the decision making on how to connect to data source! Should it be Import mode, DQ mode or both?

Read more

Time Intelligence Function

DAX users in Power bi tend always to do the same mistake, They apply Time intelligence functions on a column dates that contain duplicate dates or gaps. Wrong, very wrong!

Read more

Follow My Blog

Get new content delivered directly to your inbox.

%d bloggers like this: