Invoice date greater calendar date

[Anonymous]

When I select the date May-05-2018 its shows me the remaining dates from May-06-2018 to till Sept-09-2020. for that, I create a

CALCULATE([DD Sales],NEXTDAY('Calendar'[Date]))

its display only one date next data. like May-06-2018 how to get the remaining dates data May-07-2018 to till Sept-09-2020

then try following measure but there is one issue less of then the date is also 1, kindly guide how to resolve?

Measure = 
  VAR _Date = SELECTEDVALUE('Calendar'[Date])
  Var _Date2 = DATESINPERIOD ('Calendar'[Date],MAX ('Calendar'[Date]),-1,YEAR)
  Var _Date3 = DATESMTD('Calendar'[Date])
  Var _Date4 = MAX('Calendar'[Date])
RETURN
  IF(_Date>MAX('Test Data'[InvoiceDate]),1,0)

 

[v-lili6-msft · Accepted solution]

Hello @M_OVAISJANZEB

Try this meausre on your visual:

DATESINPERIOD = CALCULATE (
    SUM('Test Data'[Sales]),
    DATESINPERIOD (
        'Calendar'[Date],
        MAX ('Calendar'[Date]),
        3,
        YEAR
    )
)

Best regards

Lin

[Greg_Deckler]

@Anonymous - Not sure what the issue is, is it specified? Can you post sample source data as text and expected output?

Not a fan of T"I" functions. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008