Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver I
3 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    3 years ago

    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.

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver I
3 years ago

Hi MFelix 

 

I've changed etindustrialcontainerobserved[date] for 'Calendario Base'[date] in all the formulas and now all the sensors give error, not only the 102.

 

 

I don't know how to share the mockup, can you explain me step by step, please?

 

 

 

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

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.

  • Antonio_Gomez's avatar
    Antonio_Gomez
    Icon for Resolver I rankResolver I
    3 years ago

    Hi MFelix 

     

    Yes, both columns have the date/time format. The one of the Calendar (named dia) and the etindustrialcontainerobserved (named date_hour_round).

     

    I'll share via Google Drive a copy of the file, because the PBI is directly connected to a Data Base.

     

    I'll send you a private message with the link

     

    Thank you very much

     

  • Antonio_Gomez's avatar
    Antonio_Gomez
    Icon for Resolver I rankResolver I
    3 years ago

    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!!!