In this detailed post, I wanted to focus on time patterns. I will show you four different examples of ways you can utilize time intelligence functions effectivelyinside Power BI. Hopefully, by going through these examples you'll see the versatility of this great grouping of DAX functions available to us inside Power BI.
In this blog we cover how to realize asymmetric reporting requirements dynamically in a Power BI Matrix or Pivot Table. This is a typical requirements in financial forecasting and reporting.
As I see lots of ongoing questions and misinformed comments (“Power BI can’t be used for financial statements”). Here I will cover a simple approach how you can realize financial statements with dynamically calculated subtotals like profit and loss (P/L), balance sheet, cash flow etc.