Top 10 Tricky DAX Functions You Need to Know
Anurodh Kumar
Freelance PowerBI Developer | Analyzing and Visualizing Data with Microsoft Power BI, Grafana and similar tools.
1)CALCULATE: Changes the context in which data is evaluated.
2)FILTER: Applies a filter to a table based on a given condition.
3)EARLIER: Allows access to an earlier row context in nested calculations.
4)VAR: Defines variables for use within DAX expressions.
5)SUMX: Iterates over a table and sums values based on an expression.
6)RELATED: Fetches related data from another table.
7)ALL: Removes filters from a table or column for calculations.
8)VALUES: Returns a one-column table of unique values from a column.
9)TIMEINTELLIGENCE: Functions like SAMEPERIODLASTYEAR can be complex to implement correctly.
10)CONCATENATEX: Combines text values from a column into a single string with a specified delimiter.
Telco engineer | 12y+ experience in CORE Networks 2G,3G,4G,5G | Solution Architect, CORE Network engineer and Python automation passionate | LOOKING FOR A JOB OPPORTUNITY | Available for working Abroad!!!
5 个月GREAT!!!! IS THERE A EQUIVALENT IN PYTHON???