Welcoem to posts!!

in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c

ِAAA Excel English
Posted 6 days ago

Time intelligence functions in DAX (Data Analysis Expressions) are specialized functions used in Power BI and other data modeling tools to perform calculations and analysis based on time periods. They allow you to create insightful time-based reports and dashboards by handling tasks such as year-to-date, month-to-date, quarter-to-date calculations, and more.

Here are a few key examples of time intelligence functions in DAX:

1.TOTALYTD, TOTALQTD, TOTALMTD: These functions calculate the year-to-date, quarter-to-date, and month-to-date values.
DAX
SalesYTD = TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])

2.DATESYTD, DATESQTD, DATESMTD**: These functions return a table containing a column of dates for the year-to-date, quarter-to-date, and month-to-date.
DAX
DatesYTD = DATESYTD('Date'[Date])

3. PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH: These functions return a table containing a column of all the dates for the previous year, previous quarter, and previous month.
DAX
PreviousYearSales = CALCULATE(SUM(Sales[Amount]), PREVIOUSYEAR('Date'[Date]))

4. SAMEPERIODLASTYEAR: This function returns a table with a column of dates shifted one year back in time.
DAX
SalesSamePeriodLastYear = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))

5. PARALLELPERIOD: This function returns a table containing a column of dates shifted by a specified number of intervals.
DAX
SalesParallelPeriod = CALCULATE(SUM(Sales[Amount]), PARALLELPERIOD('Date'[Date], -1, YEAR))

These functions are incredibly powerful for analyzing trends, comparing performance over different time periods, and making data-driven decisions.

9 - 4

ِAAA Excel English
Posted 3 weeks ago

Which topic do you prefer most?

5 - 4

ِAAA Excel English
Posted 1 month ago

Read in 2 minutes: Data Cleaning, Ensuring Quality and Accuracy for Reliable Analysis and Decision-Making
www.aaa-power.net/english/articles/data-cleaning

4 - 0

ِAAA Excel English
Posted 8 months ago

A quick note

16 - 4

ِAAA Excel English
Posted 11 months ago

As Egyptian Pound devaluated today,
This one could be helpful

Exchange rates using excel سعر صرف الدولار باستخدام اكسيل #excel #msexcel #exceltutorial #shorts
youtube.com/shorts/AuL0VrN-qu...