none
DATE function referring to another measure not working from 13/10/2019 (DD/MM/YYYY) RRS feed

  • Question

  • I have set up the following measures:

    DataTill:=MAX(BillsList[BillDate])

    RefDateLM:=EDATE([DataTill],-1)

    Then, I used [RefDateLM] in the function DATE() as follows to get another measure as follows:

    OP_LMTD:=CALCULATE([OP],DATESBETWEEN(MyCal[Date],DATE(YEAR([RefDateLM]),MONTH([RefDateLM]),1),[RefDateLM]))

    This measure calculates another measure called [OP] for last month till date and is used in a pivot table and is updated daily. This worked perfectly fine for over 5 months till 13/10/2019 (DD/MM/YYYY).

    Since then, it is not updating. It shows the following error:

    MdxScript(Model) (6, 52) Calculation .... numeric representation of a date value was encountered

    I have searched several forums but could not find an answer as to what changed from this date in the function and why it is not working.

    Any help would be appreciated.

    Thursday, October 17, 2019 2:46 AM