rocio

[rcister]

Hello.
I need help. I need to see the mesuare accumulated

I the mesuare is:

AccumulatedYTD =
CALCULATE (
[ADR Month], FILTER (ALL (Calendar), Calendar [Date] <= MAX (Calendar [Date])))

([ADR Month] is another mesuare = ((Sum(RoomNigths))/(Sum(Reveneus)))

Thanks!

[Greg_Deckler · Accepted solution]

@rcister I am thinking:

AccumulatedYTD =
  VAR __Table = 
    ADDCOLUMNS(
      FILTER(ALL('Calendar'), Calendar[Date] <= MAX('Calendar'[Date])),
      "__ADRMonth",[ADR Month]
    )
RETURN
  SUMX(__Table,[__ADRMonth])

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work:

AccumulatedYTD = CALCULATE([ADR Month],DATESBETWEEN(Calendar [Date],MINX(ALL(CALENDAR),calendar[date]),max(calendar[date])))

Ensure that on the X-axis of your visual, you drag Year and Month from the Calendar Table.

[Greg_Deckler · Accepted solution]

@rcister I am thinking:

AccumulatedYTD =
  VAR __Table = 
    ADDCOLUMNS(
      FILTER(ALL('Calendar'), Calendar[Date] <= MAX('Calendar'[Date])),
      "__ADRMonth",[ADR Month]
    )
RETURN
  SUMX(__Table,[__ADRMonth])