Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

Need help on DAX function with measure vs column

Hello, Lastest_WorkDate = CALCULATE(MAX(LEM_FACTS[WORKDATE]))-this is measure column NO_OF_DAYS_Running Behind = DATEDIFF(LEM_FACTS[Lastest_WorkDate],TODAY(),DAY)-this is measure column Lev...
Need Help
ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

Hello,

I am getting this error" Failed to resolve name 'LEM_FACTS'. It is not a valid table, variable, or function name." My table bname is this for sure

Please

Thanks for your time

 

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Check now, had a typo, I edited it

  • ABC11's avatar
    ABC11
    Icon for Resolver I rankResolver I
    4 years ago

    Thanks its worked.

    but something is not working. Total I have 102 contract.  

     

    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      I need more info.

      Pay attenation that the solution was for a calculated column. Check that the result is correct in the data tab view. You showes a screenshot of a visual which is an aggregation on top of what we did and it depends on the filter context generated by the visual and also on the summarization of the column ( i see count, maybe you wanted sum)

      • ABC11's avatar
        ABC11
        Icon for Resolver I rankResolver I
        4 years ago

        I would like to count (no of vendor(CNRCNSUM)) who fall under those five categary. Total I have 102 CNRCNSUM. 

        This report suppose to show me - each vendor(or contract no) submit their lastest workdate invocie(we call as LEM). So we calculated maximum workdate. then we calculated no of days running behind. and then five categaroy.

        For Business summary - I would like to show how many vendor fall under which categary. 

        Would you help me please