Forum Discussion
How to use Lookupvalue in M Query from same table
Siriwat_Lukin , You have tp create a table, duplicate or copy . Then create column with
new date = Date -duration(1,0,0,0) ,
Merge both on the date and new date; then use the values from two table to create these columns
refer if needed
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Siriwat_Lukin , You have tp create a table, duplicate or copy . Then create column with
new date = Date -duration(1,0,0,0) ,
Merge both on the date and new date; then use the values from two table to create these columns
refer if needed
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Hi,
can you give the new date formula ?. I tried newdate= Date - duration(1,0,0,0). it is not working.
Thanks,
Shanthakumar.
Anonymous ,
I found same your problem.
I solved by change data type of column date to "Whole Number" and add column by custom by use formula >> date-1.
after that change data type back to "Date".
Thank you,
