Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to create an expression that will allow me to know when one type of transaction is followed by another, I.e. A void followed by a no sale. I have a table called OP_Identifier, with the column Identifier Description, which gives the transaction type, a table called Daily_Reporting_Fact which holds a column for amounts, and a table called timeofday with a column called timeofday_seconds, which I'm wanting to use as the filter so that only transactions within 10 seconds of each other are registered.
I'm pretty sure this is going to require a calculate, count, filters argument, but as to exactly what, it's above my head.
@Anonymous Thanks for the description of your problem statement. Could you please post the sample test data and expected output which help to provide an accurate solution.
Proud to be a PBI Community Champion
I'm dealing with direct query so giving a sample of the test data is rather difficult, but here are some tables with it (tuneofday_second_of_day runs through 86,400).
The idea would to be to create a matrix that reads as follows,
where if an error correct was followed by a no sale, within X seconds, it would populate cell 1:1, and so forth.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |