Today’s topics including:
[Read More]
Investment Return Rate Calculation in Power BI
Iteration of Multiplication
How to Calculate Percentage of Total in Matrix in Power BI
row and column groups from different tables
This blog simply introduces how to calculate percentage of total in Matrix with row and column groups from different tables in the model. The key DAX built-in function is ALLEXCEPT.
[Read More]
How to Pass Multiple-Values Parameters to SQL Statement
to Design a Dynamic Power BI Report
There are many articles about How to pass parameter to SQL statement in PowerBI, but none of them address my issues, so I crack it and decide to write this article to document it. If you have better method, please do let me know!
[Read More]
How to Draw an Australia Map with Label in Power BI
All the steps by using R
I’ve been struggling to get an Australia Map with Label in Power BI, finally I crack it and I just want to share my experience to you guys.
[Read More]