Tag feed

#dataanalysisexpression-dax

18 posts0 followers

Explore Hashnode

Alternatives

Trending tags this week

TCTech Concept Hubtechconcepthub.hashnode.devSep 2, 2025 · 2 min read

Skills for Success: The Top 5 Skills Companies Look for in a Fresher Data Analyst.

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...

0

QCQueen Carinequeen-carine-the-analyst.hashnode.devNov 12, 2024 · 6 min read

Giving Data a Voice that People Can Understand As a Data Analyst

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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 3 min read

Power BI Using DAX: RLS, LOOKUPVALUE, USERNAME

[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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 2 min read

Creating Power BI DAX Measures for Current and Previous Quarter Sales

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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 2 min read

Power BI DAX: CALCULATE, PARALLELPERIOD

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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 3 min read

Power BI DAX: TOPN, ASC, DESC

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 ...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 6 min read

Power BI DAX: CALCULATE, DISTINCTCOUNT, LASTDATE

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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 2 min read

Power BI DAX: CALENDAR, DATE, YEAR, TODAY

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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 16, 2024 · 2 min read

Power BI DAX: SUMMARIZE Multiple Columns

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...

0

MMMohamad Mahmoodhashnotes.hashnode.devSep 17, 2024 · 2 min read

Power BI DAX: CALCULATE, DATESBETWEEN, STARTOFYEAR, PREVIOUSYEAR, LASTDATE, SAMEPERIODLASTYEAR

Sales PYTD = VAR StartYear = STARTOFYEAR ( PREVIOUSYEAR ( 'Calendar'[Date] ) ) VAR EndDate = LASTDATE ( SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) ) RETURN CALCULATE ( [Sales], DATESBETWEEN ( 'Calendar'[Date], StartYear, EndDate ) ) Using t...

0

#dataanalysisexpression-dax

Search Hashnode

#dataanalysisexpression-dax

Explore Hashnode

Trending tags this week

Skills for Success: The Top 5 Skills Companies Look for in a Fresher Data Analyst.

Giving Data a Voice that People Can Understand As a Data Analyst

Power BI Using DAX: RLS, LOOKUPVALUE, USERNAME

Creating Power BI DAX Measures for Current and Previous Quarter Sales

Power BI DAX: CALCULATE, PARALLELPERIOD

Power BI DAX: TOPN, ASC, DESC

Power BI DAX: CALCULATE, DISTINCTCOUNT, LASTDATE

Power BI DAX: CALENDAR, DATE, YEAR, TODAY

Power BI DAX: SUMMARIZE Multiple Columns

Power BI DAX: CALCULATE, DATESBETWEEN, STARTOFYEAR, PREVIOUSYEAR, LASTDATE, SAMEPERIODLASTYEAR