Ranking is a common but tricky function in Power BI, especially when it comes to “dynamic ranking”. Requirement: Rank resellers in a table based on
Category: Data Modeling
Create a dynamic time range for forecasting Acquisition count in a certain mount of days, based on users’ selection. Solution: 1.Calculate the number of days
Do you still remember the excitement when you first wrote a DAX function that produce the correct calculation? Do you also remember the frustration when
Summary When you’re sure there is no blanks in your dimension data but still see blanks in your visuals, chances are, you have an invalid