Forum Discussion

Ninja_Powered's avatar
Ninja_Powered
Frequent Visitor
2 years ago

Visual to Display Previous Two Calendar Weeks Without Filtering Out Data

I have a Power BI report that has a DAX measure to count the number of open actions in a calendar week based on the date closed and a week end date in a calendar table. 

 

In the visual in my report I just want to display the number open this week and the number open last week per department in a table. However, when I add a date filter to the table the relationship between my calendar and data table is filtering out my actions. Adding in a second calendar table works in my simplified dataset but with two years worth of data this doesn't work. 

 

I've uploaded a simplied version of what I am trying to achieve here (if you add in a relationship between the calendar table and the date open you will see what I am seeing on my main report. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Ninja_Powered 

    I can't open your link, can I use another method to share your report?

    Best Regards

    Yongkang Hua

    • Ninja_Powered's avatar
      Ninja_Powered
      Frequent Visitor

      Anonymous I don't have permissions to upload a pbix fileso I've uploaded to my OneDrive. Please let me know if this link works here