calculated table - need to add a column with 4 items => table calculated X 4 (DAX)

[cosminc]

Hi all,

any idea how can i transform a calculated table like this:

Table = ALL ( 'Source'[Salesman], 'Source'[Year], 'Source'[Month])

i want to add a column with 4 items, so the result will be the initial table multiplied X4, with that column included

Thanks,

Cosmin

[cosminc]

i made it

I took with ALL(othertable(column))

i can step further,

Thanks

Cosmin

[parry2k · Accepted solution]

@cosminc crossjoin will get you there.

[cosminc]

Thanks

how can i write the correct syntax to a "table 2" - list of 4 items to create a crossjoin( table1, table 2 - list of 4 items)

Many thanks,

Cosmin

[parry2k]

@cosminc here is something you can do, use function DataTable

 DATATABLE( "Item", STRING, { { "A" }, { "B" }, { "C" } } )