Forum Discussion

CoboleiroBr's avatar
CoboleiroBr
Helper I
9 years ago
Solved

Date Relationship Problem

Hi guys! I'm new to PowerBI and I'd like to know if there is a way to solve that... I have a Calendar table and a Tickets table. I need two relationships to calculate Opened/Closed Tickets correctl...
Need Help
  • CoboleiroBr's avatar
    CoboleiroBr
    9 years ago

    Hello JordanAWARE !

     

    Thanks for your answer.

     

    After trying some solutions I found one that worked fine, but I had to create more tables and relationships, I'm not sure if it is the best solution, but is better than show Blank in the segmentation, because it seems there is something wrong with the database...

     

    Anyway, these steps solved the problem:

     

    1 - I created a new table containing only the Closed Tickets, where the Finish Date is filled;

    2 - A relationship between Calendar and Closed Tickets, by Finish Date;

    3 - Since I was using only one table in my report and now I'm using two, I had to create some intermediate tables/relationships to filter correcly the data in both tables.

     

    Thanks again.

JordanAWARE's avatar
JordanAWARE
Frequent Visitor
9 years ago

If you wanted to just hide Blank() from showing in the slicer just drag the field the slicer uses into a report/page filter, select all years then just uncheck blank and it will hide it.

But I dont think thats solving the issue of the blank years being there...

 

What table is that slicer reading from?

 

The next option is to try create a calculated column inside the Tickets table -->  Year = related('Calender'[year])

and use this column to slice the year

  • CoboleiroBr's avatar
    CoboleiroBr
    Helper I
    9 years ago

    Hello JordanAWARE !

     

    Thanks for your answer.

     

    After trying some solutions I found one that worked fine, but I had to create more tables and relationships, I'm not sure if it is the best solution, but is better than show Blank in the segmentation, because it seems there is something wrong with the database...

     

    Anyway, these steps solved the problem:

     

    1 - I created a new table containing only the Closed Tickets, where the Finish Date is filled;

    2 - A relationship between Calendar and Closed Tickets, by Finish Date;

    3 - Since I was using only one table in my report and now I'm using two, I had to create some intermediate tables/relationships to filter correcly the data in both tables.

     

    Thanks again.