Forum Discussion

Chetanab's avatar
Chetanab
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

DAX to work with Date table

Hi, In the attached pbix, I have a measure called backlog that works fine with the Eomonth column in History table( as in Page 2)

I am trying to fix this visual in page1 where I am using a date filter(based on date table). Is there a way to fix the backlog DAX/change userelationship to make this measure work correctly with the date filter? 

 

https://1drv.ms/u/s!Am7qubt-YFdgat_8vfm3lPWWjDk

 

Show and Tell
  • Chetanab's avatar
    Chetanab
    4 years ago

    was able to fix this by changing the backlog dax to include date table columns 🙂

4 Replies

  • Chetanab's avatar
    Chetanab
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    was able to fix this by changing the backlog dax to include date table columns 🙂

    • PC2790's avatar
      PC2790
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Please mark this as resolved by providing the solution that you followed. This will be beneficial for the people dealing with similar problem in reaching to the solution.

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Chetanab ,

     

    Can you elaborate on the requirement?

    As I understand you have a current table which has an active & inactive relationship with Date Table based on Created and Resolved date.

    What are you trying to achieve?

    • Chetanab's avatar
      Chetanab
      Icon for Microsoft Employee rankMicrosoft Employee
      4 years ago

      modified the pbix.

      I am trying to get the backlog visual to work with the year/month  slicer. It has to show the numbers displayed in expected backlog visual and also work with year/month selection from the date slicer.