Forum Discussion

rakelvillanueva's avatar
rakelvillanueva
Regular Visitor
1 year ago
Solved

help calculation

First of all, please excuse my lack of knowledge in making this inquiry. I have two tables, one for open tickets and another for closed tickets, and a table of dates (calculate dates). I have a dis...
Help
v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

Hi rakelvillanueva,

Thank you  for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank wardy912 , techies, Greg_Deckler for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

See if your Date table is marked as a Date Table and linked properly to the ticket table using the Opened Date and If the  closed / resolution Date is in another table, make sure both tables are related correctly so the formula can read both dates.

First test the formula without any slicers or extra filters. If it gives correct results, then try adding your group slicer.

If it still doesn’t work with the group slicer, the formula may need a small change so it keeps that filter active.

Hope this helps if you have any queries we are  happy to assist you further.
Best Regards,
Harshitha.

  • rakelvillanueva's avatar
    rakelvillanueva
    Regular Visitor
    1 year ago

    I have three tables:
    1. Open ticket
    2. Closed ticket
    3. Dates

    The dates table is marked as dates and linked to Open ticket and Closed ticket via an opening date and resolution date field.

      • v-hjannapu's avatar
        v-hjannapu
        Community Support
        1 year ago

        Hi rakelvillanueva,
        Just checking in to see if you had a chance to follow up on our earlier conversation. If you're still encountering the issue, please share the sample data so we can assist you with an accurate solution.

        If you have any further questions, feel free to reach out anytime.

        Regards,
        Harshitha.