Luca Liu
Luca Liu Blog
Archives
Categories
Tags
0
Home
Productivity
Data Analysis
Python
Power BI
AI
Category
Power BI: Two ways to Union Tables - DAX and Power Query
Power BI
⛱️Power BI: Two ways to Union Tables - DAX and Power Query
Combining data from multiple tables is a common requirement in Power BI. There are two primary methods to achieve this task. Using the DAX UNION function and using the Append Queries feature in Power Query are the best ways to do it. By following these two methods, you can effectively union two tables in power BI.
Power BI
DAX
Power Query
data analyst
Power BI: How to Create Dynamic Show Hide Slicer Panel
Power BI
🗂️Power BI: How to Create Dynamic Show Hide Slicer Panel
Dynamic Show Hide Slicer Panel is a way to show or hide slicer panels in Power BI. This technique allows users to switch the visibility of slicer panel as needed, optimizing space and improving usability.
Power BI
Dashboard
data analyst
Practical Tutorials
How to Use DAX Studio to Retrieve All Measures in Power BI
Power BI
🎶How to Use DAX Studio to Retrieve All Measures in Power BI
DAX Studio is an incredibly powerful tool that allows Power BI users to view and analyze their data model in great detail. One of the key features of DAX. Studio is its ability to extract all measures from a Power BI file. In this blog post, we will guide you through the simple steps to achieve this using DAX Studio.
Power BI
data analysis
data analyst
productivity
automation
Practical Tutorials
Calendar Table DAX in Power BI
Power BI
📔Calendar Table DAX in Power BI
In Power BI, a date table is necessary because the DAX language does not support built-in date functions. In Tableau, no date tables are needed as it supports built-In date functions and features. To create a dynamic date table for the most recent three years, you can use the following code.
Power BI
Dashboard
data analyst
data analysis
Hi!I am
Luca Liu

Luca Liu

 
 
Latest posts
Lazy loaded image
NotionNext: The Ultimate Solution for Notion-Based Website Building
Aug 9, 2025
Lazy loaded image
Python + AI: The Essential Skill Combination for Modern Workers Without Coding Backgrounds
Aug 9, 2025
Lazy loaded image
How to Get Started with NotionNext Quickly
Aug 8, 2025
Lazy loaded image
Solving URL Path Accumulation in NotionNext Multilingual Menus
Aug 8, 2025
Lazy loaded image
Getting Responses from Local LLM Models with Python
Aug 8, 2025
Lazy loaded image
Accessing Power BI Data with Python Using Power BI REST-API
Aug 7, 2025
data analyst
19
python
16
data analysis
11
productivity
9
Practical Tutorials
7
automation
6
pandas
5
Power BI
5
Database
4
api
3
AI
3
blog
3
Notion
3
NextJS
3
NotionNext
3
excel
2
Dashboard
2
restapi
2
Tableau
2
sql
2
LLM
2
sap
1
data
1
email
1
Oracle
1
DAX
1
Power Query
1

Articles:
4
Days Since Launch:
5 Days
Page Views:
Unique Visitors:

Powered byNotionNext 4.8.6.
2025Luca Liu | A self-taught coder who dreams of retiring early, working as a Data Analyst in Germany