Forum Discussion
Line Chart DAX
Hello, I'm once again stumped, trying to achieve what I think should be a basic result. I am trying to get a line chart to extend beyond the max date for which I have data, displaying the a flat l...
Hi Anonymous ,
According to your description, I made the sample and please follow theses steps.
Sample data: ("Table")
Firstly, create a new table to return the max date of "Updated Date".
Table 2 = ADDCOLUMNS('DATE',"1",MAX('Table'[updated date]))Then create a calculated column to return the dates of x-axis which is later than the max date of "Updated Date".
Column = IF('Table 2'[Date]>='Table 2'[1],'Table 2'[Date])We will get the "Table2" as below.
Then in "Table", create two measures.
Measure 3 =
CALCULATE(SUM('Table'[points]),FILTER(ALL('DATE'[Date]),'DATE'[Date]>=MAX('Table 2'[1])))Measure 4 =
CALCULATE('Table'[Measure 3],FILTER('Table 2',MAX('DATE'[Date])='Table 2'[Column]))Put measure 4 onto the line chart, you will get the expected output.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xiaosun-msft, Thank you so much for providing a solution! I believe I have replicated your solution using my sources.
Step 1:
Table 2 = ADDCOLUMNS('Dates',"1",MAX(stg_jira_product_team_stories_hist[Update Date]))
Step 2:
Measure 3 =
CALCULATE(SUM(stg_jira_product_team_stories_hist[Story Points]),FILTER(ALL('Dates'[Date]),'Dates'[Date]>=MAX('Table 2'[1])))
Step 3:
Measure 4 =
CALCULATE([Measure 3],FILTER('Table 2',MAX('Dates'[Date])='Table 2'[2]))
As you can see below, I'm getting a different result. For reasons I don't understand, Measure 4 is producing the SUM (total) of all Story Points from all days prior to today, and then the current total for dates => today. Can you see anything in the DAX that is causing this?
As you can see below, I'm getting a different result. For reasons I don't understand, Measure 4 is producing the SUM (total) of all Story Points from all days prior to today, and then the current total for dates => today. Can you see anything in the DAX that is causing this?