GENERATE, GENERATEALL - DAX Guide

GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results.
dax.guide/gene...
GENERATEALL: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results, including rows for which the second table expression is empty.
dax.guide/gene...
This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.

How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...
Code, run, and share DAX with DAX.do: dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[@luismart7714]

I love the way you explain things. Thanks!

[@sbn4862]

Thank you

[@Bharath_PBI]

Thank you 👍

[@ssomtom]

Thx

[@bladoblado]

Hi! Is there a real world use case for this you can remember?

[@SQLBI]

It can be useful in complex queries or measures where you need to generate combinations between different columns to use as a filter in other CALCULATE and the filter logic is not linear, so you cannot use a CROSSJOIN (or it would be too expensive to use CROSSJOIN and then FILTER).

[@opod84]

A self-join would be the best use case, would it not?

[@pbihari0214]

thank you