I dont understand why this is wrong if(month(Fecha Traslado 1)=month(Fecha de reserva),1,0)
Hi Valeria,
Is it LookML code? Where are you applying formula?
if it’s LookML then spaces in column name are not allowed, use the view column name.
To view column name go to Explore and “Info” icon.
If you are applying formula in custom calculation in Explore, then try:
if(month(${Fecha Traslado 1})=month(${Fecha de reserva}),1,0)
once you typed ${} Looker will give you list of available columns for calculation
It is not wrong inside Looker Studio if “Fecha Traslado 1” and “Fecha de reserva” are date and time expressions. Have you got a specific error message ?