Forum Discussion

Suneer's avatar
Suneer
Frequent Visitor
2 years ago

Dax Union - To Add a Static Column

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 ...
Suneer's avatar
Suneer
Frequent Visitor
2 years ago

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]))