Why Time Intelligence Fails

Power BI provides a very strong time intelligence, with a great list of functions around. But still, Time Intelligence fails. This is because the setup is not correct.

Five key points to remember

Use Date Table (Join with Fact Date)
Date table is marked as a date…


How to create report in power bi service

In December 2020, Power BI release a new feature that will allow users to create report on power BI service. You can Enter New data or use existing datasets.

Release Note: https://powerbi.microsoft.com/en-us/blog/quickly-create-reports-power-bi-service/

I have explored this feature in a Video

Please…


Power BI Download link: latest version
https://powerbi.microsoft.com/en-us/downloads/

Power BI Download link: Old versions
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

Latest update from Power BI including monthly Release Announcement
https://powerbi.microsoft.com/en-us/blog/
https://powerbi.microsoft.com/en-us/blog/category/uncategorized/

Power BI Guidance document from Microsoft
https://docs.microsoft.com/en-us/power-bi/guidance/

DAX Functions documentation
https://docs.microsoft.com/en-us/dax/

Power BI Community Support forum Link

First Refer, How to Get Your Question Answered Quickly
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1448253#M607324
Community: https://community.powerbi.com/
Desktop: https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer
Service: https://community.powerbi.com/t5/Service/bd-p/power-bi-web-app
Report Server: https://community.powerbi.com/t5/Report-Server/bd-p/ReportServer
Power Query: https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services
DAX: https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands
Mobile: https://community.powerbi.com/t5/Mobile-Apps/bd-p/power-bi-mobile
Developer: https://community.powerbi.com/t5/Developer/bd-p/Developer

Power BI Gallery:
Theme: https://community.powerbi.com/t5/Themes-Gallery/bd-p/ThemesGallery
Data Stories: https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery
Webinars and Video Gallery: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/bd-p/VideoTipsTricks
MBAS Gallery: https://community.powerbi.com/t5/MBAS-Gallery/bd-p/MBAS_Gallery

Amazing Power BI Blog by Community Users
https://community.powerbi.com/t5/Community-Blog/ct-p/PBI_Comm_CommunityBlog

New feature/s idea/suggestion to Power BI
https://ideas.powerbi.com/ideas/

Power BI Issue Reporting
https://community.powerbi.com/t5/Issues/idb-p/Issues

Power BI Support
https://powerbi.microsoft.com/en-us/support/

Custom Visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

Important Youtube Channels
Guy in a Cube: https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w
Curbal: https://www.youtube.com/c/CurbalEN
SQLBI: https://www.youtube.com/user/sqlbit
RADCAD: https://www.youtube.com/channel/UCsOfIwAXj1fT6LDqEDEAb4g
Havens Consulting: https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw
Ofcourse my Channel : https://www.youtube.com/c/Amitchandak


In this blog, we will try to answer Top 10 Frequently Asked Questions on Day Level Intelligence in Power BI.

Pre-requisites:

For any Time Intelligence, you must have a date table. Please refer the below links to create one date table.

Make sure your calendar has the following fields.(For …


In this blog, we will try to answer, 10 Most Frequently Asked Questions on Week Till Date(WTD) in Power BI.

Abbreviations:

WTD : Week Till Date
LWTD : Last Week Till Date

Pre-requisites:

For any Time Intelligence, you must have a date table. Please refer the below links to create one date table.

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Make sure your calendar has the following fields.(For a financial year, which is not same as the…


In this blog, we will try to answer, 10 Most Frequently Asked Questions on Month Till Date (MTD) in Power BI.

Abbreviations:

MTD: Month Till Date
MQTD: Last Month Till Date
LMQTD : Last Year Same Month Till Date

Pre-requisites:

For any Time Intelligence, you must have a date table. Please refer the below links to create one date table.

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Make sure your calendar has the following fields.(For a financial year…


In this blog, we will try to answer, 10 Most Frequently Asked Questions on Quarter Till Date (QTD) in Power BI.

Abbreviations:

QTD: Quarter Till Date
LQTD: Last Quarter Till Date
LYQTD : Last Year Same Quarter Till Date

Pre-requisites:

For any Time Intelligence, you must have a date table. Please refer the below links to create one date table.

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Make sure your calendar has the following fields.(For a financial year…


In this blog, we will try to answer, 10 Most Frequently Asked Questions on Year Till Date (YTD) in Power BI.

Abbreviations:

YTD: Year Till Date
LYTD: Last Year Till Date

Pre-requisites:

For any Time Intelligence, you must have a date table. Please refer the below links to create one date table.

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Make sure your calendar has the following fields.(For a financial year, which is not same as the calendar year…


When you are using a star schema for your warehouse or for reporting system and you faces data mismatch issues , then how to debug it; how to find the root cause for the mismatch. Is data mismatch is only at query level or correct data in not there in…


Data and its analysis is the need of the hour. Business Intelligence and Analytics tools are enablers for data driven culture. Often comparing data between two time slices is commonly sought after. Say, for example, one would like to compare sales of this year vs last year. Or for a…

Amit Chandak

Amit has 18+ years of experience in Business Intelligence, Analytics, Data Science. He is Chief Analytics Officer at Kanerika & Power BI community Super User

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store