Forum Discussion

corange's avatar
corange
Post Patron
6 years ago
Solved

Formatting based on condition DAX

Hi Team,    I have played with my data set so I could manipulate the Matrix view a bit more.    I have unpivot a table using two columns so now i have got :    Column "Category" where I have jo...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Seems like it should be along the lines of:

     

    Column = IF([Attribute] = "REVENUE",CONVERT([Value,CURRENCY),[Value])

corange's avatar
corange
Post Patron
6 years ago

Hi Greg_Deckler , 

 

Thanks for pointing this out. I see it now. 

 

Any idea how I would be able to use CONVERT() and obtain the same results? How write something around those lines using CONVERT(): 

 

IF ATTRIBUTE = REVENUE THEN VALUE = CURRENCY, ELSE VALUE = "" meaning not symbol. 

 

Thank you 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Seems like it should be along the lines of:

 

Column = IF([Attribute] = "REVENUE",CONVERT([Value,CURRENCY),[Value])