Forum Discussion
ambi95
Helper I
Helper IHow to sort based on text column which will change every week
Hi, I am stuck here. Attached is the matrix i have on PBI. The column headers are static data entered as a text type, showcasing a week's date range. This data will change every week...
see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RhxEUJVRvC1njL21i?e=MSsHdp
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhxCRRw-4sg9a49rB?e=F4gmfQList.Max( List.Transform( Text.Split([#"ColB - Copy"],"-"),(x)=> Number.From(try Date.FromText(Text.Trim(x), [Format = "dd MMM yy", Culture = "en-EN"])otherwise Date.FromText(Text.Trim(x), [Format = "dd MMM yy", Culture = "en-EN"] ))))
Ahmedx
Super User
Super User