What do GENERATE and GENERATESERIES do in power bi DAX

This recipe explains what do GENERATE and GENERATESERIES do in power bi DAX

Recipe Objective - What do GENERATE and GENERATESERIES do in Power BI DAX?

GENERATE - Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1.

GENERATESERIES - Returns a single column table containing the values of an arithmetic series.

Syntax of GENERATE -

GENERATE(table1, table2)

Parameters -

table1 - Any DAX expression that returns a table.

table2 - Any DAX expression that returns a table.

It returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1

Syntax of GENERATESERIES -

GENERATESERIES(startValue, endValue, [incrementValue])

Parameters -

startValue - The initial value used to generate the sequence.

endValue - The end value used to generate the sequence.

incrementValue - (Optional) The increment value of the sequence. When not provided, the default value is 1.

It returns a single column table containing the values of an arithmetic series. The name of the column is Value.

In this way, GENERATE and GENERATESERIES functions work in Power BI DAX.

What Users are saying..

profile image

Gautam Vermani

Data Consultant at Confidential
linkedin profile url

Having worked in the field of Data Science, I wanted to explore how I can implement projects in other domains, So I thought of connecting with ProjectPro. A project that helped me absorb this topic... Read More

Relevant Projects

NLP and Deep Learning For Fake News Classification in Python
In this project you will use Python to implement various machine learning methods( RNN, LSTM, GRU) for fake news classification.

Abstractive Text Summarization using Transformers-BART Model
Deep Learning Project to implement an Abstractive Text Summarizer using Google's Transformers-BART Model to generate news article headlines.

NLP Project to Build a Resume Parser in Python using Spacy
Use the popular Spacy NLP python library for OCR and text classification to build a Resume Parser in Python.

AWS MLOps Project to Deploy Multiple Linear Regression Model
Build and Deploy a Multiple Linear Regression Model in Python on AWS

Learn How to Build a Logistic Regression Model in PyTorch
In this Machine Learning Project, you will learn how to build a simple logistic regression model in PyTorch for customer churn prediction.

Loan Eligibility Prediction Project using Machine learning on GCP
Loan Eligibility Prediction Project - Use SQL and Python to build a predictive model on GCP to determine whether an application requesting loan is eligible or not.

Build Multi Class Text Classification Models with RNN and LSTM
In this Deep Learning Project, you will use the customer complaints data about consumer financial products to build multi-class text classification models using RNN and LSTM.

Loan Eligibility Prediction in Python using H2O.ai
In this loan prediction project you will build predictive models in Python using H2O.ai to predict if an applicant is able to repay the loan or not.

Deploy Transformer BART Model for Text summarization on GCP
Learn to Deploy a Machine Learning Model for the Abstractive Text Summarization on Google Cloud Platform (GCP)

Recommender System Machine Learning Project for Beginners-2
Recommender System Machine Learning Project for Beginners Part 2- Learn how to build a recommender system for market basket analysis using association rule mining.