Forum Discussion
ABC11
Resolver I
Resolver INeed 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...
SpartaBI
Community Champion
Community ChampionHey ABC11 ,
Just wrtie this funcion in a new column (I've put everyhing in one column):
Level 1 =
VAR _Lastest_WorkDate = LEM_FACTS[WORKDATE]
VAR _Diff = DATEDIFF(Lastest_WorkDate,TODAY(),DAY)
VAR _Result =
switch(
true(),
Just wrtie this funcion in a new column (I've put everyhing in one column):
Level 1 =
VAR _Lastest_WorkDate = LEM_FACTS[WORKDATE]
VAR _Diff = DATEDIFF(Lastest_WorkDate,TODAY(),DAY)
VAR _Result =
switch(
true(),
_Diff < 4,"GOOD",
_Diff<7,"Email Vendor",
_Diff<21,"Action Immediately",
_Diff<61,"Check to see if it's on site",
"Off Site")
RETURN
_Result
Hope this helps
_Diff<21,"Action Immediately",
_Diff<61,"Check to see if it's on site",
"Off Site")
RETURN
_Result
Hope this helps
ABC11Hello,
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