Forum Discussion
aldanois
6 years agoNew Member
Help with a daily evolution graph
Hi lovely community!
I'm creating a table where I intend to keep daily records of my accounts. It's important to have a daily evolution of each of my customers behavior. However, most of them may not vary in several days. Is there a way that I can avoid duplicating or triplicating the information and still be able to have day by day evolution charts?
I specifically want to know if when I get the data in power Bi, I can make a query, table or rule of some sort so that for every customer, if there's a date without information it automatically understands that the last status for the last date should be recreated until it finds a new one and so on. To fill the blanks, sort of speak.
Thanks on advice!!!
- Anonymous6 years agoHere's a solution to this in Power Query:
https://1drv.ms/u/s!ApyQEauTSLtOgYNE-QbnvwfvD4OFlA?e=QjHQAG
Best
D
2 Replies
- AnonymousNot applicableHere's a solution to this in Power Query:
https://1drv.ms/u/s!ApyQEauTSLtOgYNE-QbnvwfvD4OFlA?e=QjHQAG
Best
D - camargos88Community Champion