Best Practice and Advanced Usage of Parameters in Power BI
Interacting with SQL Server
Parameters in Power BI could be used in a lot of places: connection details, conditional column, M Query, etc. There is another “What if Parameter” which is not included in today’s topic.
[Read More]
How to Make Date Slicers for a Certain Days Cycle
Tips of using CALENDAR
I consolidated some principles of designing Power BI report based on my recent development experience and former consulting experience.
[Read More]
How to Make Peak Time Analysis based on Records with Start Time and End Time
Tips of using GENERATESERIES
I was just recovered from a really bad flu, luckily I got a fun project after recovery and found some new ideas to blog which is s a compensation to me:)
[Read More]
How to Create Custom Function in Power BI
Geocoding in Power BI by connecting API
This blog introduces how to create a “custom function” in Power BI, and I am using geocoding in Power BI by connecting API as a practice.
[Read More]