DAX provides a whole host of powerful time intelligence functions, allowing you to do things like build custom calendars, define dynamic date ranges, and compare performance over specific periods. Common Use Cases: Creating custom calendar tables with DAX instead of using the default auto-generated versions. Writing measures to calculate period-over-period, moving average, or running total […]
Prashant Parkhedkar
Prashant is an Associate Technical Consultant at Perficient in Nagpur. He is a Microsoft Certified Power BI Data Analyst Associate with over 3 years of experience. He is enthusiastic and eager to dive into the world of business analytics.
Blogs from this Author
Calculated Table Joins in Power BI
Calculated table joins are used to couple two or more tables of data. Common examples include CROSSJOIN, UNION, EXCEPT and INTERSECT. Common Use Cases for Calculated Table Joins in Power BI Blending or combining data across multiple tables. Creating advanced calculations like new vs. returning users or repeat purchase behavior. Querying tables to troubleshoot errors […]
Relationship Functions in Power BI
Relationship functions in Power BI allow you to access fields within DAX measures or calculated columns through either physical or virtual relationships between tables. Common Use Cases for Relationship Functions in Power BI Defining calculated columns or measures using fields from related tables. Handling relationships between calendars and multiple date fields (transaction date, stock date, due […]
Introduction to Power BI Dataflows
Dataflows is all about self-service data preparation inside a Power BI. Before Power BI Desktop gives you these awesome tools like power query which lets you do lightweight ETL operations on your data inside a Power BI Desktop. The challenge with this is you tended to bypass the normal ETL processes that your organization may have, […]
Row Context & Filter Context in DAX
In this article, I am going to explain what is Row Context & Filter Context in DAX. First, we know what is context. Context enables you to do dynamic analysis, in which the results of a formula can be changed to reflect the current row or cell selection and any associated data. An understanding of […]
How to Create Data Source Parameters?
In this article, I am going to explain how we can create data source parameters in Power BI. If you have different environments like Development, QA (UAT), and Production, and you want to check your reports on those environments without spending too much time changing the data sources. So, that time you need to create […]
Power BI – Cross-Report Drillthrough From One Report To Another Report For Increased Security
POWER BI – DRILLTHROUGH FROM ONE REPORT TO ANOTHER REPORT FOR INCREASED SECURITY (CROSS-REPORT DRILL THROUGH) APPLIES TO: ✓ Power BI Desktop ✓ Power BI service The traditional drill-through does not allow to drill through from one report to another report. It only works in a single report. It is a page-to-page drill-through. Cross-report drill through allows […]