Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I want to use todays date as a field in a DAX Studio Query. But no matter how I use it (so far), I've been unable to successfully implement it. Tried so many things and I'm betting the solution is so simple I'll be saying to myself "why didn't i think of that"
Here's my query
EVALUATE
SUMMARIZECOLUMNS(
RallyStories[Accepted Date],
RallyStories[Creation Date],
RallyStories[Last Updated Date],
RallyStories[In Progress Date],
RallyStories[Blocked],
RallyStories[Blocked Reason],
RallyStories[Delivery Stream],
RallyStories[Feature ID],
RallyStories[Feature Name],
RallyStories[Feature Project],
RallyStories[Flow State],
RallyStories[Flow State Changed Date],
RallyStories[Flow State UUID],
RallyStories[Formatted ID],
RallyStories[Iteration],
RallyStories[Name],
RallyStories[Owner],
RallyStories[Plan Estimate],
RallyStories[Portfolio],
RallyStories[Ready],
RallyStories[Release],
RallyStories[Release Train],
RallyStories[Schedule State],
RallyStories[Team],
RallyStories[Team UUID],
RallyStories[UUID],
KEEPFILTERS(FILTER(ALL(RallyStories[Last Updated Date]), RallyStories[Last Updated Date] >= (TODAY()-1)))
TODAY() as 'CurrentDay'
)
ORDER BY
RallyStories[Accepted Date] ASC
/* END QUERY BUILDER */
Hi @Anonymous ,
To what I can read from your code you want to return the table with only todays dates correct?
You are using a KEEPFILTER this vchanges the filter context and you are using it has part of your table try to change it to the following syntax:
FILTER (
SUMMARIZECOLUMNS (
RallyStories[Accepted Date],
RallyStories[Creation Date],
RallyStories[Last Updated Date],
RallyStories[In Progress Date],
RallyStories[Blocked],
RallyStories[Blocked Reason],
RallyStories[Delivery Stream],
RallyStories[Feature ID],
RallyStories[Feature Name],
RallyStories[Feature Project],
RallyStories[Flow State],
RallyStories[Flow State Changed Date],
RallyStories[Flow State UUID],
RallyStories[Formatted ID],
RallyStories[Iteration],
RallyStories[Name],
RallyStories[Owner],
RallyStories[Plan Estimate],
RallyStories[Portfolio],
RallyStories[Ready],
RallyStories[Release],
RallyStories[Release Train],
RallyStories[Schedule State],
RallyStories[Team],
RallyStories[Team UUID],
RallyStories[UUID]
),
KEEPFILTERS (
FILTER (
ALL ( RallyStories[Last Updated Date] ),
RallyStories[Last Updated Date]
>= ( TODAY () - 1 )
)
)
)
ORDER BY
RallyStories[Accepted Date] ASC
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
77 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
51 | |
50 | |
48 |