DAX IN operator Power BI
Published on Mar 07, 2022:
In this video, we will learnto use the DAX in operator
DAX to Build the logic is below:
SalesAmountRed=
CALCULATE (
sum(FactInternetSales[SalesAmount]),
( DimProduct[Color] )
IN
{
( "Red" )
}
)
SalesAmountRedandBlack = CALCULATE(sum(FactInternetSales[SalesAmount]),(DimProduct[Color] in {"Red","Black"}))
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
/ @learnexcelrelentless
Download DAX Editor:
https://daxstudio.org/
Our Playists:
Extract Load and Transform data using Power Query: http://bit.ly/3orLRf4
Enhance Power BI Data model using DAX: https://bit.ly/2GbTENc
Python and Power BI:https://bit.ly/2EajdNc
Getting Started with AWS: https://bit.ly/2PgSCQX
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
Getting Started with Power BI:https://goo.gl/GHakLZ
Getting Started with Python: https://goo.gl/n24P3w
Data Science With Python:https://goo.gl/PeYCR5
Power BI service: http://tiny.cc/sjekmz
Data Modelling with Power BI:https://tinyurl.com/8b4srjrm
ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License