VALUES function in DAX | DISTINCT vs VALUES | Power BI | Interview Scenario | Table Function

To download the data files used in this video .. Checkout the following link :
houseoftechconcepts.com/pages...
************************************************************************
In this video we are going to learn about VALUES function in DAX
We will cover following topics
1) What is VALUES function
2) Why Values function is used
3) We will understand the differences of VALUES and DISTINCT function
4) Hands-On to cover different topics
**********************************************************************
Playlist Link:
1) Data Warehouse : • Data Warehouse
2) Power BI - Power Query : • Power BI - Power Query
3) Power BI - Data Modeling & DAX : • Data Modeling using Po...
4) Power BI - Shorts : • Power BI - Shorts
5) SQL - Shorts : • SQL - Shorts
=============================================================
Social Media :
1) Website Link: houseoftechconcepts.com/
2) Instagram Link: / house.of.concepts
#distinct #dax #values #interview #powerbi #interviewquestion #interesting
#interviews #database #datawarehouse #subscribe #like

[@thehouseofconcepts]

To download the data files used in this video .. Checkout the following link :
houseoftechconcepts.com/pages/daxStudyMaterial.html

[@sass520]

Very Nicely Explained.Thnks😇

[@thehouseofconcepts]

Thank you so much! Please keep supporting the channel :)

[@bharathsp5542]

Nice explanation

[@thehouseofconcepts]

Thanks for your kind words !! Keep supporting the channel !!

[@wasifwaheed1879]

Sir i want to when the direction of model is not from sales to to look up table how selecting column from lookup table shoes value

[@thehouseofconcepts]

Hi.. Can you elaborate your question further ... Thanks

[@divyarawatt]

I did not understand the ending why you did not select the customer name which you creat using value function. I mean you told the value function gives us the blank value but you select the customer name from the normal table in the end. Can you explain me the last part?
I did not get it.

[@thehouseofconcepts]

Hi Divya ,
We have selected Customer Name from Customer_Lookup(Values Demo) dimension table specifically designed to showcase blank row logic .. Now, our Customer_Lookup(Values Demo) contains 18 distinct customer ids and Sales_Data fact table contains data for 19 distinct customer ids hence in matrix against one Total_Sales_Amount value Customer_Name is coming empty.If we will take normal Customer_Lookup table then this row will not be empty.
Also, same result we have also verified earlier in video when we used VALUES function on Customer_Lookup(Values Demo) customer_name column where blank row was also coming..
Hope this will clear your doubt..

[@bharathsp5542]

Sir in a table by taking new column can we use values function

[@thehouseofconcepts]

Hi,
There are two scenarios specific to VALUES function:
Case 1: returns a single column table when COLUMN is passed as input parameter
Case 2: when entire TABLE is passed as input parameter , a table of the same columns is returned..
Hope this helps !!