cancel
Showing results for
Did you mean: Frequent Visitor

## Dashboard representation through line chart

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.

1 ACCEPTED SOLUTION  Community Support

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

3 REPLIES 3  Community Support

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  Super User

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

Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!   Frequent Visitor

@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.   