Forum Discussion
Weekly total stop at today
Hello,
After looking many different postes, I still didn't find the solution for my problem.
I have a DAX total unresolved tickets, it stops at the current date when I use dateslicer, (Year/Month/Date) but It doesn't stop at today when I use the weekly dimension.
UnresolvedTicket =
CALCULATE (
COUNTA(Ticket[id]);
FILTER( ALLSELECTED(Ticket);
(Ticket[resolutiondate] = BLANK() || Ticket[resolutiondate]> Maxx (Calendrier;Calendrier[Date] ))
&& Ticket[createddate]<=Maxx (Calendrier;Calendrier[Date] )
)
)
I tried to add the IF as below but the total stop at the previous year/ month / week.
4 Replies
- amitchandak
Super User
If you are not select a date/period in the slicer . The last date will go upto last date of the calendar.
You can try putting the visual level or page level filter. There on relative and advance option, you can choose <= today
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi amitchandak,
Do you mean the filter as below ? I have to choose from calendar, what if tomorrow ? Or I misunderstood ?
Trang
- amitchandak
Check relative there should be filter forn today, tomorrow.
