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])

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Mariusz - Good call, I must have missed the introduction of that DAX function!

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Greg_Deckler 

 

It's been introduced only a few months back, but it's solving the problems we all had with FORMAT in this king of scenarios.

 

Thanks 

Mariusz

  • corange's avatar
    corange
    Post Patron
    6 years ago

    Hi, 

     

    I dont get it. I dont have an issue with FORMAT in that formula and my results are adding and not being transform as Text. 

     

    If I were to use your solution, how will it be written in a DAX Formula? The formula needs to be based on one column where we know if it is either a revenue or a job count, then use another column where I store the value and determine if Column 1 says Revenue then $ else Job Count "". 

     

    Thanks.