Data Model & DAX

https://trello.com/b/CmTvymf4/powerpivot-data-model-dax-wiki-cevi

What is Data model?

What is DAX (Data analysis expressions)?

_______________________________________________________________

• ​Multiple Criteria Filter​

• ​Using Power BI with JSON​

• ​ConcatenateX() DAX Function In Excel 2016​

• ​How To Load Data Directly Into the Excel (Power Pivot) Data Model​

• ​Create a Data Model in Excel​

• ​DAX Function Reference

• 'Year To Date - YTD': YTD Revenue:= TOTALYTD(SUM(Sales[Revenue]),'Date'[Date])

• SAMEPERIODLASTYEAR

• CALCULATE Function

• Math and Trig Functions

• Create a calculated table

• Time Intelligence Functions (DAX)

• Comparing DAX & MDX

• What is Power Pivot-1

• What is Power Pivot-2

• Where is Power Pivot?

• DateDiff Function

• Measures in Power Pivot

• KPI in Power Pivot