SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';
I declare this variables
SET vFechaAnioAtras = Date#(Now()-365,'DDMMYYYY');
When I bring my data this are my fields that brings date data
Date#(Fecha,'DDMMYYYY') As FechaNum,
YEAR(Fecha) As Anio,
MONTH(Fecha) As Mes,
Where Fecha is my field containing dates in dd/mm/yyyy format
I've been trying to get info of my sales (TotalSales) From the last 12 months from now, I've been trying using, variables, a constant and formulas, but not working at all. I Attached my App. Please help
I am guessing we are talking about the bottom chart???
Can you disable all the expression and show a straight table for the only the one expression we are trying to troubleshoot? And if possible I would add Year in the dimension to check if previous years are not flowing in.