Badriah1New Member3 years agonew column - Return extra one valueTicketsID= IF(Tickets[Year] in {2022,2023},Tickets[ID],0) Here I want to get all tickets that added in 2022 and 2023, but it return extra one value for each status.have any other solution?
1 ReplyReplies sorted by Most Likedhnguy71Super User3 years agoHi Badriah1 To assist better, would you mind sharing some sample input data and expected output?
hnguy71Super User3 years agoHi Badriah1 To assist better, would you mind sharing some sample input data and expected output?
Related contentAdd extra columninclude extra column - targetData Factory adding extra \ in JSON dataCreating custom columns keeps returning a structured Table columnField parameter slicer to add extra columns in table visual
