Forum Discussion
sudhakar111
6 years agoHelper IV
Days Bracket Filter in Report
Dear All, I need help in creating a days bucket formula, which will be used in the report as a filter. Below is the code i wrote.The problem with this is when bracket 30 is selected it shows ...
AllisonKennedy
6 years agoCommunity Champion
You may need to use custom measures for the values, rather than just normal sums in this case.
If I understand your question correctly you may be looking for something similar to a running total, that when 30 is selected, displays all 30 days or less.
There are a few ways to do this, see if this link helps, otherwise please share table and column names for your data and a desired result.
https://www.sqlbi.com/articles/computing-running-totals-in-dax/
If I understand your question correctly you may be looking for something similar to a running total, that when 30 is selected, displays all 30 days or less.
There are a few ways to do this, see if this link helps, otherwise please share table and column names for your data and a desired result.
https://www.sqlbi.com/articles/computing-running-totals-in-dax/