How can remove future dates with 0 values from the chart?

Question

Hi guys,&nbsp;as the left chart, future periods(from 2023 Apr) are showing while there's no value in query,, so what made such this thing?&nbsp;&nbsp;&nbsp;

tackytechtom · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
How does the measure [sum of delivery] look like? 🙂
&nbsp;
/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/

anonymous · Answer

Hi&nbsp;tackytechtom&nbsp;The measure is in the screenshot please see it.&nbsp;

freemanz · Answer

hi&nbsp;Anonymous&nbsp;try like:Measure =&nbsp;IF(&nbsp; &nbsp; MAX('Date'[Date])&lt;=TODAY(),&nbsp; &nbsp; [Accumulative Delivery])

anonymous · Answer

You mean to make a new measure right? I did so but didn't work,,&nbsp;

Forum Discussion

How can remove future dates with 0 values from the chart?

4 Replies

Related content

remove duplicate value within a row

Datamart future

Remove future values for running total

date hierarchy showing future value

Remove Duplicate Values in Column