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, 

 

Well when I tried it it didnt change to text, it kept it as numerical:

I have run few check and the table on the right has been created with the formula mentionned above and it is correct. There are two things I dont know how to solve though: 

 

1)  Add a delimeter "  , " as per the left example 

2) When I drag and drop my measure into my matrix which as Month & Period in Drill down, the entire calendar I use for my model appears. When I select date range, only data for the date range appear but the rest of the month doesnt dissapear as it will normally do. 

 

I hope I am making sense for point 2. 

 

Thank you

 

I hope the second point make sense. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
It is text, you can tell because it is left justified versus right justified. See your images.
  • 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])