Can any body help me with this?
I want to show Year, Month, Week or Day in a BarChart with a single If expression, but with this code, the dimension chart says "Invalid Dimension"
=If(Week(max([Fecha OM])) = Week(min([Fecha OM])) And
Year(max([Fecha OM])) = Year(min([Fecha OM])),
[Fecha OM],
If(Month(max([Fecha OM])) = Month(min([Fecha OM])) And
Year(max([Fecha OM])) = Year(min([Fecha OM])),
Week([Fecha OM]),
If(Year(max([Fecha OM])) = Year(min([Fecha OM])),
Month([Fecha OM]),
Year([Fecha OM])
)
)
)