Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have been trying to find a way to find out which vessels were booked out at a certain date in time. (would have been status O on the date choosen.)
We have a sql table where all the historical transactions are stored, the table contains the vessel number, what type is the transaction (In or Out) and the date/time of that transaction, currently over 7 million transactions.
there is no link between the transactions but the vessel must be booked in before it can be booked out again.
example of the data is below
Does anyone have any suggestions ideas? Thanks in Advance
Solved! Go to Solution.
You will need a DateTime table or better separate Date and Time tables (Time table has one row for the smallest time increment you want in your visuals), and split the DateTime column in your table to Date and Time columns. You can then relate the Date column to the Date table, and same for the time column to the Time table. From there, you just make a measure that counts the number of vessels where the max row has a type of "O".
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You will need a DateTime table or better separate Date and Time tables (Time table has one row for the smallest time increment you want in your visuals), and split the DateTime column in your table to Date and Time columns. You can then relate the Date column to the Date table, and same for the time column to the Time table. From there, you just make a measure that counts the number of vessels where the max row has a type of "O".
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |