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

Strange. Can you share your file here?