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

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

Hello,

 

I cant attach my PBI file here. Can you share your mail to me so i will mail you my PBI file.

 

Regards,

Neil

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