Forum Discussion

More_BI's avatar
More_BI
Frequent Visitor
9 years ago

Pull in only latest data from data source

Hey guys,   I currently scan through various folders and pull in a series of spreadsheets that are generated each month with the latest KPI data. The problem arises during the reporting period when...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi More_BI,

 

Is ImkeF suggestion helpful to your scenario? If so, please kindly mark the corresponding reply as an answer so that it can benefit others having similar requirements. If you still have any question, please feel free to ask.

 

Thanks,
Yuliana Gu

More_BI's avatar
More_BI
Frequent Visitor
9 years ago

Well, not entirely. It is the same way I'm doing it now. It's just many, many steps that I was hoping to reduce. Not a huge deal since it works, but I would have loved to simplify it somehow.

 

To clarify, my step #5 is the what was described in the response above. I didn't use that exact syntax but more-or-less the same logic where I created a column to check to see if there was a value in the Latest.[Column Name] then set to TRUE. Then I created a third set of columns with the latest available value (keying off my new column to tell me which version to use). I'm not too happy with this method, but again, it works.