Forum Discussion
Stack chart limit item by max date across column sections
Ibendlin, Again thanks.
You made me think and I was able to create a solution!! I will post tomorrow (on vacation today!). I created a calculated column and filtered on rows where the story point value was not blank. I made a seperate column for day, week, month and was able to create seperate pages for a stack chart on each interval using the "data" table.
Steven
calculate a DAX table with issue_id, status, story_points and week and then make it DISTINCT(). That gets rid of the duplicate IN PROGRESS in week 2
Ibendlin, Thanks for taking the time to look at this. Must appreciated!
I'm new to DAX. The code I wrote above was a big stretch for me. Would you mind giving me a little more? What do you mean by "calculate a DAX table"? Do you mean use a CALCULATETABLE?
Thanks!
There are always many ways to do things in DAX . CALCULATETABLE, ADDCOLUMNS, SELECTCOLUMS, SUMMARIZE, GROUPBY - choose your weapon as needed.
Ibendlin, Again thanks.
You made me think and I was able to create a solution!! I will post tomorrow (on vacation today!). I created a calculated column and filtered on rows where the story point value was not blank. I made a seperate column for day, week, month and was able to create seperate pages for a stack chart on each interval using the "data" table.
Steven