when i go to edit query new cols arent there nor are they in applied steps

[db042190]

hi.  just getting my feet wet.  i added 2 columns to my dataset using dax but neither shows when i edit the query.  nor does(do) the applied steps i thought would be associated with the new columns.  the formulas are shown below followed by what the editor shows.  even if i scroll to the right, the new cols dont show.  to add to my confusion, i added a filter to only show sequence 0 (i was thrilled the sum still summed on all the original rows) but the filter didnt show in applied steps either.  the filter seems to be working though.

jobtotalcost = CALCULATE( SUM( jobcost[cost] ), ALLEXCEPT( jobcost, jobcost[jobnumber] ) )
jobtotalcost2 = Sumx(filter(jobcost, jobcost[jobnumber] = earlier( jobcost[jobnumber]) ), jobcost[cost])

 

[FreemanZ · Accepted solution]

hi @db042190 

columns added with DAX is not supposed to reflect in Power Query Editor. It is the intended behavior of the SW. That is why it is always suggested to prepare the data in Power Query as much as possible.

[db042190]

thx, but i also filtered the dataset and that action isnt showing in applied steps.  should it?

[FreemanZ]

hi @db042190 

where does your filtering take place?

[db042190]

from the data view, on an original column, down arrow-> filtering, i basically instructed pbi to include only sequence numbers 0.