Forum Discussion

beginnerPBIuser's avatar
beginnerPBIuser
Frequent Visitor
3 years ago
Solved

Power BI Invalid Token Error Measure

Hello,

I have teh following error and i need help fixing it please. I am trying to get employee count for any selected month. 

Thanks

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  beginnerPBIuser ,

    I created some data:

    Here are the steps you can follow：

    1. Create measure.

    Measure =
IF(
    MAX('dim_date_2'[Date]) >=[Start Date]&&
    OR(MAX('dim_date_2'[Date])<=[End Date],[End Date]=BLANK()),1,0)
    Measure 2 =
SUMX(ALL('dim_date_2'),[Measure])

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,
    First I would define all the variables before the return statement.

    You could then make the formula under the return:
    if(employeeStartDate <= selectedDate && employeeEndDate >= selectedDate,1,0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  beginnerPBIuser ,

    I created some data:

    Here are the steps you can follow：

    1. Create measure.

    Measure =
IF(
    MAX('dim_date_2'[Date]) >=[Start Date]&&
    OR(MAX('dim_date_2'[Date])<=[End Date],[End Date]=BLANK()),1,0)
    Measure 2 =
SUMX(ALL('dim_date_2'),[Measure])

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly