Forum Discussion

cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago

Managing relationship with filtered queries

Hi everyone,   I am currently using powerbi desktop to connect to an oracle 12cr2 database by direct query.    I have a couple of queries (that are just copies of each other) that have been intro...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Could you add a custom column to each query that identifies its time horizon and then Append all of them together? Sorry, I am not visualizing how your data looks very well, sample/example data would help.

cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago

Hi smoupre,

 

Thank you for your reply. 

 

I think I understand your idea, but you think this appending action can be done automatically? 

 

For example, if i have 4 separate queries that filters data from 12mn to currenttime of the day + next (5, 10, 15, 20mins)  (so technically, rows are unfiltered throughout the day) , will these still be reflected on to that appended query without any human intervention?