Forum Discussion

NeilAm12's avatar
NeilAm12
Icon for Helper I rankHelper I
7 years ago
Solved

Additional Column for Previous Data Based on Previous Time and Filter

Hello All,   Need your help, i need to get the previous data of Data-Xi column base on Entry Date/Time based with filter of MiniCompany and Machine #. I tried many formula but it shows error. Con...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    I think this error is occuring because there is a duplication combination of Mini Company, Entry Date/Time and Machine#.  For the LOOKUPVALUE() function to work, each row combination should be unique

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi NeilAm12 ,

 

You could upload your sample PBIX file onto OneDrive and share the downloaded link here. Remember to hide sensitive data in file.

 

Best regards,

Yuliana Gu

NeilAm12's avatar
NeilAm12
Icon for Helper I rankHelper I
7 years ago

Hello,

 

Please see below link.

I don't know if you can access it, this is my 1st time to use OneDrive.

 

Regards,

Neil