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.
Hello,
i have a data table with the 3 colums and i hope to get the last one:
Identification number | travel date | Reservation class | TYPE |
HAZERTY | 11/01/2019 | BI | 1st class |
HAZERTY | 15/02/2019 | BI | 1st class |
TYOPJRV | 12/03/2019 | BI | MIX |
TYOPJRV | 13/03/2019 | BZ | MIX |
i have every time 2 lines for each Iden. number, for the earlier date of the identification number i have always BI but for the return (the later date of the identification class) i can find BI or BZ. if i have 2 times BI for the same identification number i want to call it 1st class and if i have another value for the return i want to call it mix
i am looking to get the colonne TYPE but i just can't find the way after spending few hours with this.
I tried a :
Solved! Go to Solution.
thank you it work, didn't know before the all except!! 🙂
@Anonymous
Seems you are just missing the earlier function
Column = CALCULATE ( DISTINCTCOUNT ( 'A_R MALIN'[Reservation class] ), FILTER ( 'A_R MALIN', 'A_R MALIN'[identification number] = EARLIER ( 'A_R MALIN'[identification number] ) ) )
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |