Forum Discussion
Production identifier
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 tha...
Jihwan_Kim
Super User
Super UserHi, 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