You could do something like:
Measure New: IF [Month] == "Juli" THEN 480 ELSE [Measure] END
thanks for you help but that is not the solution to my question..
Sorry, I guess the issue you're trying to solve isn't clear to me.
Could you post an example encapsulated Tableau workbook (twbx) with an example of the problem?
Check out the attached workbook.
I duplicated (right-click, duplicate) the measure field Totaal gel. CV [GJ] and then edited the new field to look for the erroneous value on July 1, 2012 and replace it with the correct value.
Totaal gel. CV [GJ] CORRECTED
IF [Maand] == DATE("July 1, 2012") THEN 7.84
ELSE ([Waarde] * 3.6) / 100
Sample Jim_jim.twbx.zip 28.1 KB
1 of 1 people found this helpful
That's strange. When I open the workbook, it works.
Perhaps the date formatting / locale is different and that causes the date match to fail? The header on that view when I open the workbook is "July 2012". Maybe try editing the formula to use DATE("2012-07-01")? In any case, you need to match the [Maand] dimension.
Yep your right!
It was a language issue.
Thanks for your help!!!!!