license:mit size_categories:n<1K format:csv modality:text library:datasets library:pandas library:mlcroissant library:polars region:us infinite-dataset-hub synthetic
---
license: mit
tags:
- infinite-dataset-hub
- synthetic
---

# DAXTrends

tags: Trend Analysis, Forecasting, Time Series

_Note: This is an AI-generated dataset so its content may be inaccurate or false_

**Dataset Description:**

The 'DAXTrends' dataset comprises various textual examples of DAX expressions used within Power BI for trend analysis, forecasting, and time series data manipulation. Each entry in the dataset is accompanied by an explanation or use case scenario, illustrating how the DAX expression would be applied in real-world data analysis scenarios.

**CSV Content Preview:**

```csv
"labels","dax_expression","description"
"Trend Identification","CALCULATE(SUM('SalesData'[Revenue]),FILTER('SalesData', 'SalesData'[Date]>=DATE(2021,1,1) && 'SalesData'[Date]<=DATE(2021,12,31)))","Calculate the total revenue for the year 2021 to identify sales trends."
"Seasonal Forecasting","SEASONAL_FORECAST('ForecastData'[Value],DATE(2022,1,1),24) AS 'Quarterly Forecast 2022'","Forecast the next 24 quarters using the Seasonal Forecast function in Power BI."
"Time-Aware Aggregation","CALCULATE(AVERAGE('CustomerData'[Rating]),FILTER('CustomerData', 'CustomerData'[PurchaseDate]>'2021-01-01')) AS 'Average Rating Post-2021'","Calculate the average customer rating for purchases made after January 1st, 2021."
"Dynamic Time Range","CALCULATE(MIN('FinancialData'[Profit]),FILTER('FinancialData', 'FinancialData'[Date]>MAX('FinancialData'[Date])-365)) AS 'Last Year's Profit'","Find the minimum profit made in the last year from the dataset's current date."
"Custom Index Creation","EOMONTH('CalendarData'[Date],-1) AS 'End of Month'","Create a custom index based on the end of each month using the EOMONTH function."
```

This dataset includes a diverse range of examples that cover different aspects of DAX expression usage in Power BI, from basic calculations and filters to more advanced functions like forecasting and creating dynamic time ranges. Each example is labeled with a descriptive label to indicate the type of DAX expression and its application in analyzing time series data.

**Source of the data:**

The dataset was generated using the [Infinite Dataset Hub](https://huggingface.co/spaces/infinite-dataset-hub/infinite-dataset-hub) and microsoft/Phi-3-mini-4k-instruct using the query 'Power BI DAX expression examples':

- **Dataset Generation Page**: https://huggingface.co/spaces/infinite-dataset-hub/infinite-dataset-hub?q=Power+BI+DAX+expression+examples&dataset=DAXTrends&tags=Trend+Analysis,+Forecasting,+Time+Series
- **Model**: https://huggingface.co/microsoft/Phi-3-mini-4k-instruct
- **More Datasets**: https://huggingface.co/datasets?other=infinite-dataset-hub
