Forum Discussion
NithinBN
Helper II
Helper IIPerform historical analysis using main data and change log.
Hello All,
how can I do perform historical analysis based on Initial State and Change Log data.
to get a table like this.
Should I create a new table or connect those 2 tables somehow to get a table like the above ?
4 Replies
- amitchandak
Super User
NithinBN , to me it seems like append in power query or Union in DAX
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
NithinBN
- Greg_Deckler
Community Champion
Table = GENERATE( SUMMARIZE('Table1',[Data],[ID]), SUMMARIZE('Table2',[State],[Priority]) )NithinBN Seems like you want something like:
- NithinBN
Greg_Deckler : I want somethink like, if we use summarize, we either have entry of 20th or 21 and 23.
