Navigate

DAX Kya Hota Hai?

DAX ka full form hai Data Analysis Expressions.
Ye ek formula language hai jo Power BI, Excel Power Pivot, aur SSAS Tabular Models me use hoti hai.

Soch lo ki DAX ek Excel jaise formulas ka advance version hai, jo aapko data analysis aur calculations karne deta hai zyada powerful aur dynamic tareeke se.

DAX Overview – Hinglish Me Samjhaaya Gaya

💡 DAX Kya Hota Hai?

DAX ka full form hai Data Analysis Expressions.
Ye ek formula language hai jo Power BI, Excel Power Pivot, aur SSAS Tabular Models me use hoti hai.

Soch lo ki DAX ek Excel jaise formulas ka advance version hai, jo aapko data analysis aur calculations karne deta hai zyada powerful aur dynamic tareeke se.

🔧 DAX ka Role Power BI aur Excel Me

✅ Power BI Me DAX ka Use:

  1. Custom Measures & KPIs banane ke liye
    Jaise: Total Sales, Profit Margin, Growth Rate, etc.
  2. Calculated Columns create karne ke liye
    Jaise: FullName = FirstName & " " & LastName
  3. Time Intelligence Functions
    Jaise: Previous Month Sales, YTD (Year to Date), etc.
  4. Conditional Logic (IF/AND/OR)
    Jaise: Agar Sales > 100000 hai to “High Performer” dikhana.

✅ Excel Me (Power Pivot) DAX ka Use:

  1. Relational Data Models par kaam karne ke liye
  2. PivotTables me custom calculations define karne ke liye
  3. Dynamic filters ke sath data manipulate karne ke liye

🧠 DAX aur Excel Formulas Me Difference?

Excel FormulasDAX
Cell based hoti hainColumn or Table based hoti hain
Har ek cell ke liye alag calculationPura column ya table pe calculation
Simple calculations ke liye theekComplex & dynamic analytics ke liye perfect

🧪 DAX Ke Kuch Common Functions

  • SUM(), AVERAGE(), COUNT(), MIN(), MAX()
  • CALCULATE() – most powerful function hai
  • FILTER(), ALL(), RELATED(), IF(), SWITCH()
  • DATESYTD(), PREVIOUSMONTH(), TOTALYTD()

🔍 Real-Life Example in Power BI

Agar aapko Power BI report me dikhana hai:

“Last Month ka Sales total”

To DAX formula ho sakta hai:

LastMonthSales = CALCULATE(SUM(Sales[Amount]), PREVIOUSMONTH(Sales[Date]))

📌 Conclusion – DAX Kyu Seekhna Chahiye?

  • Agar aap Power BI Expert banna chahte hain, to DAX must-have skill hai.
  • Ye aapke reports ko interactive, dynamic, aur insightful banata hai.
  • Data ke andar ke patterns aur trends samajhne me madad karta hai.
डिजिटल:
Related Post