PinnedSreenivas MadduRELATED Vs RELATEDTABLE DAX Function in Power BIRELATED and RELATEDTABLE are two powerful functions in DAX that help you navigate relationships between tables and retrieve data from…Feb 5Feb 5
Sreenivas MadduWhat are the key features of Power BI?Power BI is a powerful business analytics tool developed by Microsoft that helps organizations visualize and share insights from their…Jan 8Jan 8
Sreenivas MadduWhat’s a View?In SQL, a View is like a virtual window into your data, created from the brilliance of another SQL statement. Beyond just simplifying…Dec 31, 2023Dec 31, 2023
Sreenivas MadduDateAdd vs ParallelPeriodTime Intelligence functions in Data Analysis Expressions (DAX) are a set of functions designed to facilitate the analysis of data over…Dec 13, 2023Dec 13, 2023
Sreenivas MadduUnleashing the Power of Cross JoinSQL interviews can be challenging, requiring a blend of theoretical knowledge and problem-solving skills. It’s not just about understanding…Sep 19, 2023Sep 19, 2023
Sreenivas MadduWhat is the significance of Query Folding in Power BI, and why should it matter to you?Query folding in Power BI refers to The process of pushing data transformation steps, such as filtering, sorting, and aggregation, back to…Jul 27, 2023Jul 27, 2023
Sreenivas MadduA Guide to COALESCE() and ISNULL() Functions with Hands-On ExamplesHandling NULL values in SQL is crucial to ensure accurate and meaningful data analysis. NULLs represent missing or unknown information, and…Jul 21, 2023Jul 21, 2023
Sreenivas MadduUnderstanding the PARSENAME Function in SQL ServerThe SQL PARSENAME function is used to extract certain parts of an object name, such as a table name, column name, or database name, based…Jul 19, 2023Jul 19, 2023
Sreenivas MadduDifference between Max(Date) and lastdate(Date) in DaxThe MAX(Date) function in DAX is a scalar function that returns the maximum value from a given column of dates. It is used to find the…Jul 5, 2023Jul 5, 2023