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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rgpsathish
Frequent Visitor

Power BI Backlog issue DAX

Hi Experts,

 

i created the Open Task report Visualization, in this report we can see the Created, closed and backlog Task. i have one concern backlog showing more than today date as well. i dont want to see the backlog more than today date.

 

please support.

 

this is my backlog DAX:

Balance = [Created]-[Closed]

Backlog = CALCULATE([Balance],FILTER(ALL('Dates'),'Dates'[Date]<=max('Dates'[Date])&&NOT(ISBLANK('Dates'[Date]))))

 

 

 

rgpsathish_1-1692686539614.png

 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @rgpsathish ,

Please try:

Backlog = IF(MAX('Dates'[Date])<=TODAY(),CALCULATE([Balance],FILTER(ALL('Dates'),'Dates'[Date]<=max('Dates'[Date]))))

There will be no blank values on the 1 side of a valid relationship.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

4 REPLIES 4
rgpsathish
Frequent Visitor

Thanks @v-cgao-msft 

v-cgao-msft
Community Support
Community Support

Hi @rgpsathish ,

Please try:

Backlog = IF(MAX('Dates'[Date])<=TODAY(),CALCULATE([Balance],FILTER(ALL('Dates'),'Dates'[Date]<=max('Dates'[Date]))))

There will be no blank values on the 1 side of a valid relationship.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

JoeBarry
Solution Sage
Solution Sage

Hi @rgpsathish 

 

Quickest way to achieve what you want is to

 

  • Highlight the visual
  • Go to the filter pane
  • In Date go to Relative date.
  • Choose Is in the last...
  • Select the amount of Days or Months or Years
  • Then Apply filter

Thanks

Joe

Hi @JoeBarry ,
Thanks for your quick reply,

 

same filer only i applied now. but the issue iss if i select month entire month visible in Chart but value showing >today also that's my concern 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors