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

FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, LASTNONBLANKVALUE - DAX Guide

SQLBI
120K subscribers
15K views 3 years ago #powerpivot #dax #powerbi
FIRSTNONBLANK: Returns the first value in the column for which the expression has a non blank value. https://dax.guide/firstnonblank/ LASTNONBLANK: Returns the last value in the column for which the expression has a non blank value. https://dax.guide/lastnonblank/ FIRSTNONBLANKVALUE: Returns the first non blank value of the expression that evaluated for the column. https://dax.guide/firstnonblankvalue/ LASTNONBLANKVALUE: Returns the last non blank value of the expression that evaluated for the column. https://dax.guide/lastnonblankvalue/ 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
FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, LASTNONBLANKVALUE - DAX Guide
178Likes
15,511Views
2022Jun 2
FIRSTNONBLANK: Returns the first value in the column for which the expression has a non blank value. https://dax.guide/firstnonblank/ LASTNONBLANK: Returns the last value in the column for which the expression has a non blank value. https://dax.guide/lastnonblank/ FIRSTNONBLANKVALUE: Returns the first non blank value of the expression that evaluated for the column. https://dax.guide/firstnonblankvalue/ LASTNONBLANKVALUE: Returns the last non blank value of the expression that evaluated for the column. https://dax.guide/lastnonblankvalue/ 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

120K subscribers