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

OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR - DAX Guide

SQLBI
120K subscribers
4.9K views 3 years ago #powerpivot #dax #powerbi
OPENINGBALANCEMONTH: Evaluates the specified expression for the date corresponding to the end of the previous month. https://dax.guide/openingbalancemonth/ OPENINGBALANCEQUARTER: Evaluates the specified expression for the date corresponding to the end of the previous quarter after applying specified filters. https://dax.guide/openingbalancequarter/ OPENINGBALANCEYEAR: Evaluates the specified expression for the date corresponding to the end of the previous year after applying specified filters. https://dax.guide/openingbalanceyear/ 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
OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR - DAX Guide
77Likes
4,976Views
2022Jun 9
OPENINGBALANCEMONTH: Evaluates the specified expression for the date corresponding to the end of the previous month. https://dax.guide/openingbalancemonth/ OPENINGBALANCEQUARTER: Evaluates the specified expression for the date corresponding to the end of the previous quarter after applying specified filters. https://dax.guide/openingbalancequarter/ OPENINGBALANCEYEAR: Evaluates the specified expression for the date corresponding to the end of the previous year after applying specified filters. https://dax.guide/openingbalanceyear/ 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