Forum Discussion
Solved
Function Dateadd problem
Hello Everyone! I need some help, please. I created a matrix with some data from sensors. The columns shows the sensor, the client, the product, the volume that measures, an alert message, th...
Hi Antonio_Gomez ,
Does your calendar table is a date/time format?
To share a file you can use a onedrive, google drive, we transfer or similar link to upload your files. If the information is sensitive please share it trough private message.
Hi Antonio_Gomez ,
Does your calendar table is a date/time format?
To share a file you can use a onedrive, google drive, we transfer or similar link to upload your files. If the information is sensitive please share it trough private message.
Hi MFelix
Finally with your comments my problem was solve.
Although I was using a Calendar table, the format of the columns were different. One was date+hour and the other was date.
And, I changed the formulas to:
VolumenHace8Dias =
VAR __lastDate = MAX(etindustrialcontainerobserved[date])
VAR DiasAtras = 8
RETURN
CALCULATE(
[ultimo_volumen],
FILTER(
etindustrialcontainerobserved,
etindustrialcontainerobserved[date] = __lastDate - DiasAtras)
)
To explain why the PBI was working well and suddenly not, it is about showing the actual volume of products in tanks and forecasting their volume.
When one sensor stopped sending data for a whole day, missing data such as the date appeared. The contiguous error happened because I was using the dates from the sensor's table and not the ones from the Calendar table.
After changing the date column, formulas and direction in the relationships between tables the problem was solve!!!