Sign in to confirm you’re not a bot
This helps protect our community. Learn more

DISTINCT, VALUES - DAX Guide

SQLBI
121K subscribers
20K views 4 years ago #powerpivot #dax #powerbi
DISTINCT: Returns distinct (unique) values in a column or from a table expression. https://dax.guide/distinct/ VALUES: Returns distinct (unique) values in a column or all the rows (including duplicates) from a table expression, in both cases with the additional blank row if present. https://dax.guide/values/ This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot ...more
...more
DISTINCT, VALUES - DAX Guide
245Likes
20,194Views
2021Jun 24
DISTINCT: Returns distinct (unique) values in a column or from a table expression. https://dax.guide/distinct/ VALUES: Returns distinct (unique) values in a column or all the rows (including duplicates) from a table expression, in both cases with the additional blank row if present. https://dax.guide/values/ This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot

Follow along using the transcript.

SQLBI

121K subscribers