esProc Desktopesproc-desktop.hashnode.dev·Apr 18, 2024SPL XLL Practice: Almighty Text Splitting in ExcelText splitting is a common problem encountered in work. For common splitting with commas, semicolons, spaces, and other delimiters or regular fixed-width splitting, Excel’s “text to columns” function can be directly used for splitting. However, more ...Discussexcel
Daniel Hayestech-marketer.hashnode.dev·Apr 5, 2024Maximizing Business Potential with Advanced Data Visualization and Analytics SolutionsIn today's rapidly evolving business environment, harnessing the power of data visualization and analytics tools is indispensable for organizations striving to maintain a competitive edge. Let's delve into the pivotal role of data visualization in tr...Discussdata analytics
Kevin Millerkevinmiller.hashnode.dev·Apr 4, 2024Power BI for Everyone: Leverage No-Code Analytics for Strategic DecisionsIn today's data-driven world, businesses of all sizes are swimming in an ocean of information. From sales figures to customer behavior, website analytics to supply chain logistics, the amount of data available is staggering. But having data is one th...Discusspowerbi developer
Sweta_Sarangiswetasarangi.hashnode.dev·Mar 28, 2024Additional time intelligence calculationsThe FIRSTDATE and the LASTDATE DAX functions return the first and last date in the current filter context for the specified column of dates. Calculate new occurrences Another use of time intelligence functions is to count new occurrences. The followi...DiscussMicrosoft
Sweta_Sarangiswetasarangi.hashnode.dev·Mar 27, 2024Use DAX time intelligence systemDAX includes several time intelligence functions to simplify the task of modifying date filter context. You could write many of these intelligence formulas by using a CALCULATE function that modifies date filters, but that would create more work. Not...DiscussMicrosoft
Sweta_Sarangiswetasarangi.hashnode.dev·Mar 27, 2024Choose a technique to add a column in PowerBIThere are three techniques that you can use to add columns to a model table: Add columns to a view or table (as a persisted column), and then source them in Power Query. This option only makes sense when your data source is a relational database and...DiscussPowerBI
Sweta_Sarangiswetasarangi.hashnode.dev·Mar 27, 2024Row context in PowerBIThe formula for a calculated column is evaluated for each table row. Furthermore, it's evaluated within row context, which means the current row. Consider the Due Fiscal Year calculated column definition: DAXCopy Due Fiscal Year = "FY" & YEAR('Du...DiscussPowerBI
Sweta_Sarangiswetasarangi.hashnode.dev·Mar 27, 2024Add calculated tables and columns to PowerBI modelsYou can create a calculated table in your model using a Data Analysis Expressions (DAX) formula. This formula can either replicate or modify existing model data to generate a new table. Calculated columns in import models have a cost: They increase t...DiscussMicrosoft
esProc Desktopesproc-desktop.hashnode.dev·Mar 26, 2024Set Operations of Excel Inter Row Data (Intersection, Union, and Difference)In the workplace, it is common to encounter tasks that require merging and comparing data from two or more spreadsheets, where duplicate data needs to be picked out. This is essentially a conventional set operation, but Excel cannot directly support ...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Mar 23, 2024Set Operations of Data Between Excel Columns (Intersection, Union, and Difference)Sometimes in work, we may encounter situations where two or more sets of data intersect or union, but Excel itself does not support direct set operations. For set operations, a series of functions need to be used to implement them, which is cumbersom...Discussexcel
