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.
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://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://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://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://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…
