Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i need to show Latest Month and cycle field in text box . my month field is like C10 2017, C92017 ,C82017. i can not do max as we i have all the 12 cycle in data all the time.
but i have a column in data that tell this is latest cycle.)
Month field column
c10 2017 Latest cycle
c10 2017 Latest cycle
.
.
.
c09 2017 Last cycle
i want to show Last cycle Month field in text box.
TIA!
Try this ?
Only({<column = {'Last cycle'}>}[Month field])