Except DAX function

  • HI ,

    I have one column in pivot table Col1, in that column I have the data like Open, Cancle and Close, I want to display that column col1 with only Open, Cancel

    Like Col1 NOT IN (Close)

    Is there any DAX function, Can you please let me know How I can get that using DAX function

    Thank You,

    Grace

  • Hi Grace,

    Do you want to display Open and Cancel only in another column?

    Please explain!

    DJTRIN

  • Look at the Filter function

    🙂

  • Are you trying to remove the display of values from the rows in your pivot table; or, are you trying to do something else?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply