How to stop a line

Question

Hi,I have created 2 measures for the cumulative sales. 1 for Previous fiscal year and 1 for Current Fiscal year for the completed months. At the moment March is still not completed that's why this is not in scope of the line for Current fiscal year. I would like to end this line after the last completed month, but I do not know how. Can you help me? See my formula below!My result now is shown here:&nbsp;My desired result should be:&nbsp;Formula Current Fiscal Year:Current Fiscal Year Cumulative Sales for completed months = CALCULATE(&nbsp; &nbsp; SUM(Append3[EUR Sales]),&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Calendar Posting Date'),&nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[CurFiscalYearOffset] = 0 &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[FiscalMonthNum] &lt;= MAX('Calendar Posting Date'[FiscalMonthNum]) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[CurrentDayOffset] &lt; 0 &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[CurMonthOffset] &lt;= -1&nbsp; &nbsp; ))&nbsp;

freemanz · Answer

hi&nbsp;JC2022&nbsp;try to plot a measure like this instead:Measure =
IF(
    MAX('Calendar Posting Date'[Date]&lt;=MAX(Append3[Date]),
    [Current Fiscal Year Cumulative Sales for completed months]
)&nbsp;

jc2022 · Answer

Hi FreemanZ&nbsp;This formula gives the following error: Too few arguments were passed to the IF function. The minimum argument count for the function is 2.

freemanz · Answer

Sorry, try like:Measure =IF(MAX('Calendar Posting Date'[Date])&lt;=MAX(Append3[Date]),[Current Fiscal Year Cumulative Sales for completed months])&nbsp;forgot to close the bracket.&nbsp;

jc2022 · Answer

FreemanZ&nbsp;This is the result of this formula. Not what I was expecting.&nbsp;

jc2022 · Answer

FreemanZ&nbsp;I have also tried the following formula:FYTD Sales = VAR CurMonthOffset = MAX('Calendar Posting Date'[CurMonthOffset])RETURN&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; IF(CurMonthOffset &gt; -1, BLANK(), SUM(Append3[EUR Sales])),&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Calendar Posting Date'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[CurFiscalYearOffset] = 0 &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[FiscalMonthNum] &lt;= MAX('Calendar Posting Date'[FiscalMonthNum]) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Posting Date'[CurrentDayOffset] &lt; 0 &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF('Calendar Posting Date'[CurMonthOffset] &gt; -1, BLANK(), 'Calendar Posting Date'[CurMonthOffset] &lt;= -1)&nbsp; &nbsp; ))The result will only show the line for January and February and not the first 3 month of the Fiscal Year.&nbsp;

Forum Discussion

How to stop a line

5 Replies

Related content

Stop line chart showing values past today

Stopping our Mirroring

How to stop rule firing

Open Mirroring Stops Working

Stop line between category