Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate error or Data format issue?

I have two data tables:   Monthly Targets Grid Gate Month Plan San Joan 6. Installed January 39 Orange 6. Installed January 18 North 6. Installed January 22 West 6. Installe...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Does your actual table have month columns? If it does, you need to pivot plan table or unpivot actual table. The final goal is to let two tables have the same format. Then you can use LOOKUPVALUE() function to get your result.