Sep 2, 2025 · 2 min read · Are you a recent graduate or a career changer aiming to become a Data Analyst? The tech world is hungry for data talent, but companies are looking for more than just technical knowledge. To stand out from the crowd, you need to master a combination o...
Join discussion
Nov 12, 2024 · 6 min read · Introduction Data storytelling is essential for any data analyst in today's data-driven world. Raw numbers and graphs only go so far; to drive real impact, data needs a narrative that brings insights to life. Data storytelling bridges the gap between...
Join discussion
Sep 17, 2024 · 3 min read · [Country] = LOOKUPVALUE(Managers[Country], Managers[ManagerName], USERNAME()) Row Level Security (RLS) is a feature in Power BI that restricts data access for users at the row level. It ensures that users can only see the data that they are permitte...
Join discussionSep 17, 2024 · 2 min read · Sales Previous Year = CALCULATE ( [Total Sales], PARALLELPERIOD ( 'Date'[Date], -1, YEAR ) ) The CALCULATE() function in DAX is essential for modifying the context of a calculation, allowing you to apply specific filters or conditions. When integrat...
Join discussionSep 17, 2024 · 3 min read · TopNValues = TOPN(<N_Value>, <Table>, <OrderBy_Expression>, [<Order>[, <OrderBy_Expression>, [<Order>]]…]) The TOPN function in DAX (Data Analysis Expressions) is used to return the top 'N' rows from a specified table or expression based on a given ...
Join discussionSep 17, 2024 · 2 min read · Previous Quarter = CALCULATE ( [Total Sales], PREVIOUSQUARTER ( Date[Date] ) ) To create a measure that displays the sales from the previous quarter, you can use the PREVIOUSQUARTER function in DAX. This function returns a table that contains all th...
Join discussionSep 17, 2024 · 6 min read · CALCULATE ( DISTINCTCOUNT ( Balances[AccountID] ), LASTDATE ( 'Date'[Date] ) ) In data analysis, understanding the number of unique accounts at specific points in time is crucial for tracking performance and making informed decisions. The DAX expres...
Join discussionSep 17, 2024 · 2 min read · DateTable = CALENDAR ( DATE ( 2020, 1, 1 ), DATE ( 2022, 12, 31 ) ) To create a Date Table in Power BI using a DAX expression, you can use the CALENDAR or CALENDARAUTO functions. The CALENDAR function allows you to specify a date range, while CALEND...
Join discussionSep 16, 2024 · 2 min read · YearlySalesByRegion = SUMMARIZE( Sales, 'Date'[Year], Sales[Region], "Total Sales", SUM(Sales[Sale]) ) The SUMMARIZE function in DAX is a versatile tool for creating summary tables by grouping data based on multiple columns. This function allows us...
Join discussionSep 17, 2024 · 2 min read · Sales PYTD = VAR StartYear = STARTOFYEAR ( PREVIOUSYEAR ( 'Calendar'[Date] ) ) VAR EndDate = LASTDATE ( SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) ) RETURN CALCULATE ( [Sales], DATESBETWEEN ( 'Calendar'[Date], StartYear, EndDate ) ) Using t...
Join discussion
