Introducing calendar-based time intelligence in DAX SQLBI 2026-09-25 | Introducing calendar-based time intelligence in DAX
Introducing window functions in DAX SQLBI 2023-01-31 | This video introduces the syntax and functionalities of the new DAX window functions: INDEX, OFFSET, and WINDOW. Article and download: https://sql.bi/784024?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Debugging DAX measures in Power BI SQLBI 2023-01-17 | Learn how to debug a DAX measure that returns an incorrect result by using different techniques, with and without external tools. Article and download: https://sql.bi/782334?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Variations on like for like comparison - Unplugged #45 SQLBI 2023-01-11 | Discover how we answer a student question requesting a variation of the like-for-like calculation, computing the sales in other stores only considering the brands sold in the selected store. Download sample file: sqlbi.com/tv/variations-on-like-for-like-comparison-unplugged-45 Read more about the "unplugged" format: sqlbi.com/blog/marco/2021/01/09/the-unplugged-video-series-on-sqlbi-youtube-channel/?aff=yt #unplugged
What happened in DAX in 2022 SQLBI 2022-12-30 | A recap of the news in the DAX world in 2022 and a preview of what we expect in 2023.Happy New Year! Links and more details in the related blog post: sqlbi.com/blog/marco/2022/12/30/what-happened-in-the-dax-world-in-2022/?aff=yt
Many-to-Many Relationships - The Whiteboard #12 SQLBI 2022-12-28 | The many-to-many cardinality relationship in DAX is not what a many-to-many relationship is for the rest of the world... Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
ERROR - DAX Guide SQLBI 2022-12-27 | ERROR: Raises a user specified error.https://dax.guide/error/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Custom Date Templates with Bravo for Power BI SQLBI 2022-12-20 | This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool. Article and download: https://sql.bi/779793?aff=yt Bravo for Power BI: https://bravo.bi/?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
One-to-One Relationships - The Whiteboard #11 SQLBI 2022-12-14 | The one-to-one relationship is just a particular type of one-to-many relationship... Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE - DAX Guide SQLBI 2022-12-12 | USERNAME: Returns the domain name and user name of the current connection with the format of domain-nameuser-name. https://dax.guide/username/ USEROBJECTID: Returns the current user’s Object ID from Azure AD for Azure Analysis Server and the current user’s SID for on-premise Analysis Server.https://dax.guide/userobjectid/ USERPRINCIPALNAME: Returns the user principal name.https://dax.guide/userprincipalname/ CUSTOMDATA: Returns the value of the CustomData connection string property if defined; otherwise, BLANK().https://dax.guide/customdata/USERCULTURE: Returns the culture code for the user, based on their operating system or browser settings.https://dax.guide/userculture/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Solving errors in CALCULATE filter arguments SQLBI 2022-12-08 | This video explains the more common errors in CALCULATE filter arguments and how to solve them. Article and download: https://sql.bi/778253?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Regular and Limited Relationships - The Whiteboard #10 SQLBI 2022-11-30 | Do you know the difference between regular and limited relationships in DAX? Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
ISSUBTOTAL - DAX Guide SQLBI 2022-11-28 | ISSUBTOTAL: Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise.https://dax.guide/issubtotal/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Welcome to SQLBI+ SQLBI 2022-11-22 | SQLBI+ is our new subscription service to advanced content that support professional model authors who create semantic models for Power BI and Analysis Services. Read more on sqlbi.com/articles/welcome-to-sqlbi-plus
Filters based on content of other tables in Power BI - Unplugged #44 SQLBI 2022-11-21 | How can you move a filter from one table to another without a relationship in Power BI? By using the DAX code shown in this unplugged video! Download sample file: sqlbi.com/tv/filters-based-on-content-of-other-tables-in-power-bi-unplugged Read more about the "unplugged" format: sqlbi.com/blog/marco/2021/01/09/the-unplugged-video-series-on-sqlbi-youtube-channel/?aff=yt #unplugged
Invalid Relationships - The Whiteboard #09 SQLBI 2022-11-16 | An invalid relationship in DAX is a regular relationship that has bad data... Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
SELECTEDMEASUREFORMATSTRING - DAX Guide SQLBI 2022-11-14 | SELECTEDMEASUREFORMATSTRING: Returns format string for the measure that is currently being evaluated.https://dax.guide/selectedmeasureformatstring/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Introducing horizontal fusion in DAX SQLBI 2022-11-08 | Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this video, we introduce this optimization with some examples. Article and download: https://sql.bi/772850?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Bravo for Power BI v1.0 Launch SQLBI 2022-11-02 | Bravo is a free tool created by SQLBI that helps you create a Power BI model with a simple user interface: Analyze Model, Format DAX, Manage Dates, and Export Data are the features available in this release. Download: https://bravo.bi Documentation: docs.sqlbi.com/bravo Announcement: http://www.sqlbi.com/articles/bravo-for-power-bi-1-0-released
SELECTEDMEASURENAME - DAX Guide SQLBI 2022-10-31 | SELECTEDMEASURENAME: Returns the name of the measure that is currently being evaluated.https://dax.guide/selectedmeasurename/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Why Power BI totals might seem wrong SQLBI 2022-10-25 | A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this video, we explain the reasons why those totals are correct. Article and download: https://sql.bi/772093?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
One-to-Many Relationships - The Whiteboard #08 SQLBI 2022-10-19 | The basic relationships are one-to-many in most databases, DAX is no exception! Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
ISSELECTEDMEASURE - DAX Guide SQLBI 2022-10-17 | ISSELECTEDMEASURE: Returns true if one of the specified measures is currently being evaluated.https://dax.guide/isselectedmeasure/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Using cross highlight with order and delivery date in Power BI SQLBI 2022-10-11 | How to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date. Article and download: https://sql.bi/769807?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Storage Engine (VertiPaq) - The Whiteboard #07 SQLBI 2022-10-05 | How does the VertiPaq storage engine communicate with the formula engine when executing a DAX query? Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
SELECTEDMEASURE - DAX Guide SQLBI 2022-10-03 | SELECTEDMEASURE: Returns the measure that is currently being evaluated.https://dax.guide/selectedmeasure/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Introducing RANKX in DAX SQLBI 2022-09-27 | RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. Article and download: https://sql.bi/760169?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Formula Engine - The Whiteboard #06 SQLBI 2022-09-21 | Let's draw what the formula engine does when executing a DAX query. Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH - DAX Guide SQLBI 2022-09-19 | PATH: Returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy.https://dax.guide/path/ PATHCONTAINS: Returns TRUE if the specified Item exists within the specified Path.https://dax.guide/pathcontains/ PATHITEM: Returns the nth item in the delimited list produced by the Path function.https://dax.guide/pathitem/ PATHITEMREVERSE: Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path.https://dax.guide/pathitemreverse/PATHLENGTH: Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID at the top/root of a hierarchy.https://dax.guide/pathlength/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Introducing ALLSELECTED in DAX SQLBI 2022-09-13 | Introduction to ALLSELECTED, which is an extremely complex function to use in DAX. Article and download: https://sql.bi/760153?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Variables - The Whiteboard #05 SQLBI 2022-09-07 | A variable is a constant in DAX. Is it more clear if we draw it? Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
DEFINE TABLE - DAX Guide SQLBI 2022-09-05 | The DEFINE TABLE statement introduces a table definition in a query (also known as query table).https://dax.guide/st/table/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Using RELATED and RELATEDTABLE in DAX SQLBI 2022-08-30 | Why and when to use RELATED and its companion function RELATEDTABLE: two common DAX functions that are required when using a row context with relationships. Article and download: https://sql.bi/751669?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Expanded Table - The Whiteboard #04 SQLBI 2022-08-25 | What is an expanded table in DAX? Seeing it is better than a simple description! Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
DAX Studio 3 announcement SQLBI 2022-08-24 | DAX Studio 3.0 is now available: watch the announcement! Download from daxstudio.org
DEFINE COLUMN - DAX Guide SQLBI 2022-08-22 | The DEFINE COLUMN statement introduces a table column in a query (also known as query column).https://dax.guide/st/column/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Computing sales made to customers before and after a period SQLBI 2022-08-16 | How to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month. Article and download: https://sql.bi/760164?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Context Transition - The Whiteboard #03 SQLBI 2022-08-10 | A context transition in DAX transforms a row context into an equivalent filter context: a picture is worth a thousand words! Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
DEFINE MEASURE - DAX Guide SQLBI 2022-08-08 | The DEFINE MEASURE statement introduces a measure definition in a query (also known as query measure).https://dax.guide/st/measure/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Variables in DAX SQLBI 2022-08-02 | Using variables in DAX makes the code easier to read, faster, and easier to debug. Learn how and when to use variables, along with why they are so important in any DAX expression. Article and download: https://sql.bi/760161?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Row Context - The Whiteboard #02 SQLBI 2022-07-27 | Learn what the row context is in DAX with a more graphical explanation! Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
VAR - DAX Guide SQLBI 2022-07-25 | The VAR keyword introduces variables in an expression.https://dax.guide/st/var/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Rolling average with working days in DAX SQLBI 2022-07-19 | This article shows how to compute a rolling average (useful to smooth out charts) taking into account only the working days. Article and download: https://sql.bi/757611?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Filter Context - The Whiteboard #01 SQLBI 2022-07-14 | Introduce the filter context in the first episode of The Whiteboard! Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/?aff=yt #thewhiteboard
EVALUATE, ORDER BY - DAX Guide SQLBI 2022-07-11 | EVALUATE is a DAX statement that is needed to execute a query. https://dax.guide/st/evaluate/The ORDER BY keyword is part of the EVALUATE statement and defines the sort order of the result produced by EVALUATE.https://dax.guide/st/order-by/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Hiding measures by using object level security in Power BI SQLBI 2022-07-05 | This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Article and download: https://sql.bi/757626?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Understanding the optimization of SWITCH SQLBI 2022-06-28 | The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Article and download: https://sql.bi/754856?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR - DAX Guide SQLBI 2022-06-16 | CLOSINGBALANCEMONTH: Evaluates the specified expression for the date corresponding to the end of the current month. https://dax.guide/closingbalancemonth/ CLOSINGBALANCEQUARTER: Evaluates the specified expression for the date corresponding to the end of the current quarter after applying specified filters.https://dax.guide/closingbalancequarter/ CLOSINGBALANCEYEAR: Evaluates the specified expression for the date corresponding to the end of the current year after applying specified filters.https://dax.guide/closingbalanceyear/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR - DAX Guide SQLBI 2022-06-13 | STARTOFMONTH: Returns the start of month.https://dax.guide/startofmonth/STARTOFQUARTER: Returns the start of quarter.https://dax.guide/startofquarter/STARTOFYEAR: Returns the start of year.https://dax.guide/startofyear/ENDOFMONTH: Returns the end of month.https://dax.guide/endofmonth/ENDOFQUARTER: Returns the start of quarter.https://dax.guide/endofquarter/ENDOFYEAR: Returns the start of year.https://dax.guide/endofyear/ 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR - DAX Guide SQLBI 2022-06-09 | 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: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot
Using KEEPFILTERS in DAX SQLBI 2022-06-08 | This video explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX. Using FEEPFILTERS simplifies the code and improves performance. Article and download: https://sql.bi/751682?aff=yt How to learn DAX: sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
