Forum Discussion
Solved
How to add a column with previous week values in Power Query/Power Bi
I have a set of weekly data, I just want to add the previous week's amount next to current week's Amount. This will help me to find the difference between the weeks. I have attached he sample fi...
You may merge the table with itself using Prior Week on left side and Week on right one , like
#"Merged Queries" = Table.NestedJoin( #"Promoted Headers", {"Subscription Code", "Product Category", "Prior Week"}, #"Promoted Headers", {"Subscription Code", "Product Category", "Week"}, "Promoted Headers", JoinKind.LeftOuter ),Just expand Amount after that and apply desired cosmetic.
Hi mathetes
FILTER function is not working for me, Can you please help me with some other approach?
FILTER function is not working for me, Can you please help me with some other approach?
Help you with what? You jumped in on this thread "from the side," so to speak, a thread that had ended half a year ago. And you jumped in without any introduction as to what you're doing.
It would be better to start a whole new thread. And I would strongly suggest you consider helping others help you by posting a copy of your spreadsheet, the one where the "FILTER function is not working."
- ok