Dashboard representation through line chart

[Whoule]

Hi,

I am having trouble figuring this one out. We have a dashboard that we normally update twice a month. I am trying to show, through a line chart, the progress we make on the outstanding volume of transaction we need to process. My problem is that for each month, the values are summarized therefore, at the end of the month, the result on the chart is the combination of the outstanding volume at the 15th and the 30th. I only what the chart to take in account the last value entered for the month.

Example: 

Date	Outstanding Items	Results on dashboard
September 15 2021	500	500 (which is the correct value of outstanding item at the time)
September 30 2021	600	1100 (which is not the correct value we want to represent at the end of the month) We would like to show that the outstanding volume at the end of september is 600)

Thank you very much in advance.

[v-yangliu-msft · Accepted solution]

Hi  @Whoule ,

Here are the steps you can follow：

1. Create calculated column.

Month = MONTH('Table'[date])

2. Create measure.

Measure =
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])&&'Table'[date] = MAXX(FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])&&'Table'[date]=MAX('Table'[date])),[date])))

3. Result:

Does this match your expected result

Best Regards,

Liu Yang

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

[Greg_Deckler]

@Whoule It sounds like Lookup Min/Max: Lookup Min/Max - Microsoft Power BI Community

[Whoule]

@Greg_Deckler Thank you. Could you help identifying what term to put where in your measure formula?
Here is a picture of what the data looks like.