Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Find articles, guides, information and community news

Most Recent
amitchandak
Super User
Super User

The time Intelligence in Power BI makes it easy to calculate Year till date (YTD), Quarter till date (QTD) and Month till date (MTD) and to compare them to the same period last year and last period. How will this work in a Direct query environment?

Let us try to see the same in a Direct Query SQL Server Environment.

Read more...

amitchandak
Super User
Super User

Power BI Time Intelligence functions provide a powerful way to get different types of time periods and time comparisons. Some of these are MTD, PMTD, PYMTD, MOM, MOYM, QTD, LQTD, QOQ, YTD, LYTD YOY etc. But dealing with a non-standard period can be a bit difficult, especially when months are not the standard months. In this article, we try to take on a case of non-standard periods (months).

Read more...

EnterpriseDNA
Kudo Kingpin
Kudo Kingpin

Using DAX to compare data or metrics over time is incredibly efficient. Using a range of techniques in this post I'll show you how to analysis performance of these metrics over multi-year time periods.

 

Multi Year Performance Analysis.JPG

Read more...

EnterpriseDNA
Kudo Kingpin
Kudo Kingpin

One type of analysis I like to use quite often is comparing this year totals to last year totals. I want to also always make it as dynamic as possible. All I should have to do is change the context of my calculation (ie. bring in a new dimension like regions/products etc) and everything should automatically re-calculate.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.