Vivek KumarUnderstanding the Difference Between RELATED and RELATEDTABLE in DAXIntroductionAug 22Aug 22
Vivek KumarUnderstanding the Importance of Context in Power BI: A Deep Dive into DAX and Data ModelingIn the realm of Power BI, a phrase often heard is that a „column should be in context.“ This concept is crucial for anyone working with DAX…Aug 22Aug 22
Vivek KumarHow to have better Time ManagementIn a world saturated with productivity advice, I found myself drowning in a sea of books and TED Talks, desperately seeking the magic…Jan 1Jan 1
Vivek KumarBinary Tree Traversal methodsA tree is a frequently-used data structure to simulate a hierarchical tree structure. Each node of the tree will have a root value and a…Dec 10, 2023Dec 10, 2023
Vivek KumarFILTER vs CALCULATETABLE DAX FunctionsDAX (Data Analysis Expressions) is a powerful formula language used in Power BI, Power Pivot, and Analysis Services to perform calculations…Sep 23, 2023Sep 23, 2023
Vivek KumarHow to use SQL Rank and Dense Rank function in analysisThe SQL RANK function assigns a rank to each row within a result set based on the value of a specified column. Rows with the same value in…Feb 20, 2023Feb 20, 2023
Vivek KumarSQL CASE statement with aggregate functioncase statement works similar to if else statement. It compares a categorical feature from the column and gives the possibility to filter…Sep 16, 2022Sep 16, 2022