Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TechR21
Helper V
Helper V

calculating a value based on other column

I have the following data

 

TechR21_0-1668778448408.png

 

a ticketnumber has an id in the ticketdetails table. This id is linked with the table tickets. A ticket has a majorticketid, or is blank (when there is no major ticket assigned).

 

When there is a majorticket assigned, this also has a ticketnumber in the table ticketdetails.

 

Now i need to be able to create a column ticketdetails table, that basically says;

when ticket.majorticketid is not empty then ticketdetailsticketnumber, otherwise blank

 

both tables are linked via ticketid, one on one relationship.

 

 

3 REPLIES 3
amitchandak
Super User
Super User

@TechR21 , A new column in ticketdetails

 

related(ticket[majorticketid])

 

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

I dont need the majorticketid, I need the ticketdetailsticketnumber when majorticketid is not empty

@TechR21 , In the tickets table , assuming both are joined

 

maxx(relatedtable(ticketdetails),[ticketdetailsticketnumber])

 

else add filter

 

maxx(filter(ticketdetails,ticketdetails[ticket id] = tickets[ticket id]) , ticketdetails[ticketdetailsticketnumber])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.