Help with model fix

Question

Hello,I have an issue with my model, it was working perfectly but all of a sudden I am getting the below error. It relates to one of the formula below howver I can not find anything wrong with the formula. Additionally, if I refresh each of the tables individually on transform data it works however if I hit refresh on the visuals then it gives the below error. Please help I am not entirely sure what wrong or how to fix. I have also sent frown which directed mHT - Days Worked = VAR targetstartdate= SELECTEDVALUE('Global Staff Targets'[Target Start Date])VAR endomonth = ENDOFMONTH(Dates[Date])VAR startmonth = STARTOFMONTH(Dates[Date])VAR enddate = IF(TODAY()&gt;=endomonth,endomonth,TODAY())VAR startdate = IF(targetstartdate&lt;=startmonth,startmonth,targetstartdate)RETURN IF(DATEDIFF(startdate, enddate,DAY) &lt;0,0, (DATEDIFF(startdate, enddate,DAY)))+1&nbsp;

v-easonf-msft · Accepted Answer

Hi,&nbsp;Anonymous&nbsp;
The error detail has shown that 'A column specified in the call to function 'ENDOFMONTH' is not Type of DATE'.

Please check if your Table ‘Dates’&nbsp; is continuous and the data type of date[date] is &nbsp;of type DATE.
You can refer to these related threads.
Reason for error: 'A column specified in the call to function 'PARALLELPERIOD' is not of type DATE'&nbsp;
A column specified in the call to function is not of type date&nbsp;
MdxScript(Model) (8, 67) Calculation error in measure A column specified in the call to function&nbsp;
&nbsp;
Best Regards,Community Support Team _ Eason

Forum Discussion

Help with model fix

1 Reply

Related content

Modelling

Data Modeling

Cannot Load Model

Semantic Model

Healthcare Semantic Model