Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I have a problem that I can't solve. I should create a calculated column that identifies a certain routing to me. I have the timestamp of each cycle and the cycle number available. My idea is that of: if the N ° cycle is equal to 0 I write in all the lines the starting timestamp for that cycle and so on until I find zero again. I attach screenshots to try to explain better. It can be done?
Actual Scenario:
Timestam | N. Cicle |
04/06/2021 08:59 | 0 |
04/06/2021 09:01 | 1 |
04/06/2021 09:03 | 2 |
04/06/2021 10:15 | 0 |
04/06/2021 10:17 | 1 |
Timestam | N. Cicle | Id. Production |
04/06/2021 08:59 | 0 | 040620210859 |
04/06/2021 09:01 | 1 | 040620210859 |
04/06/2021 09:03 | 2 | 040620210859 |
04/06/2021 10:15 | 0 | 040620211015 |
04/06/2021 10:17 | 1 | 040620211015 |
Hi, @Carlend
Please check the below picture and the sample pbix file's link down below.
It is for creating a new column.
ID Production CC =
CALCULATE (
LASTNONBLANK ( 'Table'[Timestam], MAX ( 'Table'[Timestam] ) ),
FILTER (
'Table',
'Table'[Timestam] <= EARLIER ( 'Table'[Timestam] )
&& 'Table'[N. Cicle] = 0
)
)
https://www.dropbox.com/s/dbo7x3xa2cha10w/carlend.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |