Hope you're safe and doing well!
I'm trying to duplicate the max date row 4 times for each store ID.
For example- Max date for Store name A is 4/21/2022. Now I want to duplicate this row 3 more times and this should work for each Store Name.Input-
Attached below are the sample data and the pbix file. @amitchandakwill highly appreciate it if anyone can help me with this.
Go to Solution.
Hi @Anany ,
In this case you need to use Power query and do the following:
Duplicate the Query that you have and then add the following steps after your transformations:
= Table.Max([ALL ROWS], "Index.INVOICE_DATE")
See result attach.
Proud to be a Super User!
View solution in original post
Thank you so much !! It's working perfectly fine.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.