Dax Union - To Add a Static Column

[Suneer]

I've generated a Union Query in DAX and included a static field named "MainAccount" (highlighted in red). This functionality functions correctly in Power BI. However, when I attempt to replicate the same in a paginated report, an error is encountered. The provided DAX query serves as an example. Assistance in resolving this issue would be greatly appreciated.

SampleTable1 = Union(
selectcolumns(SampleTable1,
"Company", SampleTable1[Company],
"Invoice Date", SampleTable1[InvoiceDate]
"MainAccount", "SalesAccount"),
selectcolumns(SampleTable2,
"Company", SampleTable2[Company],
"Invoice Date", SampleTable2[InvoiceDate],
"MainAccount", "CostAccount"))

[Suneer]

I observed that when incorporating a static field in a DAX query within a paginated report, it should be positioned last. (see the mistake I did in the following example. The example i shown in the original post was correct )  . In my situation, I mistakenly positioned the static field between other fields.

Eg.

SampleTable1 = Union(
selectcolumns(SampleTable1,
"MainAccount", "SalesAccount",
"Company", SampleTable1[Company],
"Invoice Date", SampleTable1[InvoiceDate])
,
selectcolumns(SampleTable2,
"MainAccount", "CostAccount",
"Company", SampleTable2[Company],
"Invoice Date", SampleTable2[InvoiceDate]))

[some_bih]

Hi @Suneer UNION "wants" proper column structure for underlying columns.

Check link for this functions https://learn.microsoft.com/en-us/dax/union-function-dax?WT.mc_id=DP-MVP-4025372 

[some_bih]

Hi @Suneer 

for both  "SalesAccount" and  "CostAccount" you will need table reference (usually)