Forum Discussion
How to Remove a Column Using DAX
Hey Everybody,
I am looking at removing an entire column from a table in Power BI by using DAX
The column that I am trying to remove is highlighted in yellow below.
I know that I can right-click on the column, and exclude the column, but I don't want to do that though (because doing so is not compatible when creating this same Power BI report as a paginated report in the cloud). I want to use DAX to do the same thing. In other words, I want to remove "Channel" = "Agency" and 'type" = "Paperless" by using DAX.
Does anyone know how?
Thanks
Dan
i820017 , Create a measure like
calculate(sum(Table[Value]), filter(Table, Table[Channel] = "Agency" && [type] = "Paperless"))
1 Reply
i820017 , Create a measure like
calculate(sum(Table[Value]), filter(Table, Table[Channel] = "Agency" && [type] = "Paperless"))