Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 introduced to this filter below:
#"custom step"=Table.SelectRows(#"Name of Previous Step", each ([Datetime]) <=(DateTime.LocalNow()+#duration(0,0,X,0)))
where X is different time horizons, (5, 10, 15, 20 etc. ) for each of those queries. FYI, this filter is used to show some data over the next 5, 10 , 15 20 mins that is based on the local time of the machine.
For example i have these 4 queries, that looks over the next 5 , 10, 15 , 20 mins of the current time. I would now like to be able to "LINK" ALL these queries in ONE graph, wherein I can use a SLICER to choose between what time horizon I want to view on that graph.
I have tried merging, but the issue with that, i believe, is that the lengths of the columns are NOT the same. and also there are unique values i think.
We have also tried looking into relationships between these tables, but it seems to have the same issue.
Is there a work around on this one?
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.
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?
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |