Forum Discussion

FlowViz's avatar
FlowViz
Helper III
4 years ago

Help with query across tables

Hi Guys,   I have a Jira dataset structured like so (edit: table name - Cycle Time 2):   And I also have a date table:   I want to be able to count: 1) How many items are In Progre...
Need Help
FlowViz's avatar
FlowViz
Helper III
4 years ago

Thank you!

 

One final question - if there have been no changes to items then there will be no updates to the history, however they will still be 'In Progress'. So if my current chart now looks like this:

It should stay at the value of 3 for the 22/23/24/25 March.

Is there anyway to do this?

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, FlowViz 

 

Try to create another measure like this:

_sum = SUMX(FILTER(ALLSELECTED('CycleTime (2)'),'CycleTime (2)'[ChangedDate]<=MAX('CycleTime (2)'[ChangedDate])),[_count])

Result:

Please refer to the attachment below for details.

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.