Forum Discussion
Solved
How to use Lookupvalue in M Query from same table
Hello, I am Siriwat, Beginner for M language of Power BI. I want to create energy report from Electrical meter that accumulate data as below : and the data that i want in yellow column...
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/
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,
Hi,
I used below one.
Date.AddDays([Date],(-1))
Thanks,
Shanthakumar.