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 everyone,
I am trying to add a journey number for the time period to the Vehicles.
One journey would be completed when it is left from the base and returned to the base.
Attached is the expected column "Journey Number".
Thanks
Solved! Go to Solution.
Hi @Tejaswini_Dahat,
You can create calculated columns like below:
C1 = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Vehicle No]=EARLIER('Table'[Vehicle No])&&'Table'[TIMESTAMP]<=EARLIER('Table'[TIMESTAMP])))
C2 = var nextvalue=CALCULATE(MAX('Table'[LOCATION]),FILTER('Table','Table'[Vehicle No]=EARLIER('Table'[Vehicle No])&&'Table'[C1]=EARLIER('Table'[C1])+1))
return IF('Table'[LOCATION]="BASE" && nextvalue<>"BASE",1,0)
C3 = SUMX(FILTER('Table','Table'[Vehicle No]=EARLIER('Table'[Vehicle No])&&'Table'[TIMESTAMP]<=EARLIER('Table'[TIMESTAMP])),'Table'[C2])
Best Regards,
Qiuyun Yu
Hi @Tejaswini_Dahat,
You can create calculated columns like below:
C1 = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Vehicle No]=EARLIER('Table'[Vehicle No])&&'Table'[TIMESTAMP]<=EARLIER('Table'[TIMESTAMP])))
C2 = var nextvalue=CALCULATE(MAX('Table'[LOCATION]),FILTER('Table','Table'[Vehicle No]=EARLIER('Table'[Vehicle No])&&'Table'[C1]=EARLIER('Table'[C1])+1))
return IF('Table'[LOCATION]="BASE" && nextvalue<>"BASE",1,0)
C3 = SUMX(FILTER('Table','Table'[Vehicle No]=EARLIER('Table'[Vehicle No])&&'Table'[TIMESTAMP]<=EARLIER('Table'[TIMESTAMP])),'Table'[C2])
Best Regards,
Qiuyun Yu
Hey @v-qiuyu-msft , Thank you so much, for your efforts & this solution works perfectly 🙂
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |