Power BI DAX Interview Questions & Answers| Concatenate | Concatenatex |Sum| Sumx|ALL|GenerateSeries

#powerbidax #powerbidaxfunction #powerbi_training
In this video we discuss important Power BI DAX Interview Questions.
1. What is the difference between CONCATENATE and CONCATENATEX?

CONCATENATE: Joins two text strings into one text string.
CONCATENATEX : Evaluates expression for each row on the table, then return the concatenation of those values in a single string result,
separated by the specified delimiter.

2.What is the difference between SUM and SUMX?

SUM is a simple aggregation function.
It summarizes a value based on a filter context.
SUM only accepts a column name as input.

SUMX is an iterator function and takes a different approach.
Unlike SUM, SUMX is capable of performing row-by-row calculations
and iterates through every row of a specified table to complete the calculation.

3.Does ALL override a page level Filter /Report level Filter?

Will discuss through practical example

4.What is the use of GENERATESERIES DAX?

GENERATESERIES(startValue, endValue[, incrementValue])
Returns a single column table containing the values of an arithmetic series

🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example:    • difference between parallelperiod and same...  
👉2.How to Calculate Running Totals:    • How to calculate running total in power bi  
👉3.Duplicate Vs Reference :    • power bi difference between duplicate and ...  
👉4.Merge Vs Append:    • power bi difference between merge and append  
👉5.Calculate Function in DAX Power BI:    • What is Calculate Function in Power BI DAX...  
👉6.Filter Function in Power BI:    • Filter Function in Power BI DAX  
👉7.Row Vs Filter Context:    • Row Context Vs Filter Context in Power BI  
👉8.ALL DAX Function:    • How to use ALL Dax Function in Power BI | ...  
👉9.ALL Vs ALLSELECTED :    • allselected dax|all vs allselected dax | p...  
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT :    • All Vs AllSelected Vs AllExcept | Power BI...  
👉11.ALL Vs REMOVEFILTERS :    • ALL Vs REMOVEFILTERS Difference in Power B...  
👉12.TOPN Dax Usage :    • TOPN Dax | How to use topn dax in power bi...  
👉13.Summarize Dax Function in Power BI:    • summarize dax | How to use summarize in DA...  
👉14.Summarize Vs Summarizecolumn :   • summarize vs summarizecolumns | how to use...  
👉15.Calendar Vs CalendarAuto :    • Calendar Vs Calendar Auto Dax Function| Po...  
👉16.How to create a date table in Power BI :    • how to create a date table in power bi: st...  
👉17.How to calculate Running total for date values in Power BI
   • How to calculate Running total for date va...  
👉18.How to calculate running total in power bi for non date values:    • Running Total in Power BI for non date Val...  
👉19.Usage of datediff in Power BI:    • Power BI datediff dax Usage with Example| ...  
👉20.Isblank() Vs Isempty :    • Power BI ISBlank DAX Function with IF Cond...  
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
https://powerbizone.com/category/arti...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥