Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Except DAX function Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 12:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:51 PM
Points: 25, Visits: 151

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
Post #1463257
Posted Thursday, October 10, 2013 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 6:21 AM
Points: 2, Visits: 30
Hi Grace,

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

Please explain!

DJTRIN

Post #1503580
Posted Friday, October 11, 2013 3:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:57 PM
Points: 204, Visits: 1,328
Look at the Filter function

Post #1503932
Posted Friday, February 28, 2014 1:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
Are you trying to remove the display of values from the rows in your pivot table; or, are you trying to do something else?
Post #1546569
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse