Forum Discussion
Helper IDashboard 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.
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
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
Community Champion
Whoule It sounds like Lookup Min/Max: Lookup Min/Max - Microsoft Power BI Community
WhouleGreg_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.
