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.
Hi
I have a table with hudred thousands lines structured as below
DATE CAR REF MOVE
01.01.2022 RNTX1 Entered
08.03.2022 RNTX1 Entered
15.08.2021 RNTX2 Get Out
22.02.2022 RNTX1 Get Out
20.02.2022 RNTX1 Fixed
....
There is dates from 01.01.2018 till today
There is a incalculable number of CAR REFERENCE
There is 3 possible MOVES : Entered / Fixed / Get Out
My goal is to create a table based on dates like below knowing that the CAR REF is doing the rount trip hundered times
CAR REF ENTERED FIXED GET OUT
RNTX1 01.01.2022 20.02.2022 22.02.2022
RNTX2 ..... .... ....
.... ..... .... ....
RNTX1 .... .... ....
.....
Based on your request, it appears all you need to do is create a matrix visualization with the data and ensure that your data model is connected correctly. Without more information about what you are exactly trying to create though I don't know if we can help you more than that.
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 |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |