Forum Discussion
PowerRobots99
Helper II
Helper IIPower Query Custom Column Calculation
Hello Everyone, I am having weekly data in attached sheet with column ("Report Date" to "Completed Week") which i have imported in Power BI. Now, i have to develop custom column "In Prior Weeks ...
Hi, here you go
AngeloParana
Resolver I
Resolver ICreate a custom key and do self join on the previous table.
key is like thise (reportweek-1) + WO#
PowerRobots99Thank you for your reply,
I have uploaded excel file and .pbix file for your reference,
https://drive.google.com/file/d/11Ml22csv7DTZX-Ck16mpQ1u0aTdzDWP7/view?usp=drive_link
Could you please incorporate solution and share the. pbix file
Thank you,
PowerRobots
- AngeloParana
Hi, here you go