POWER BI: Modeling

Statistical Functions

GENERATE functions

Returns a table of Cartesian products

Syntax

Example Formula:

In the Power BI formula bar write:

                  
                generate_all = GENERATE(BusinessTable,AdTable)   
	            

Power BI Demo:

Using Generate on the AdTable and BusinessTable

The demo shows generate returning a table with both all rows from the Ad Source table and all rows from the Business Type table.