Forum Discussion
Solved
LOOKUPVALUE returns blank value
Hello, Following the recent help of Jahida (thanks again!), I managed to do some good progress with the dashboard I'm preparing for my boss. Unfortunately, I'm facing a new problem, related to LOOK...
Please create a new column in Time table with following formual.
Time_Format = FORMAT ( 'Time'[Time], "Long Time" )
Then update the Shift column formula as below. It should can resolve the problem.
Shift = LOOKUPVALUE ( Time[Shift], 'Time'[Time_Format], FORMAT( Yearly[Time(Adj)], "Long Time" ) )
The root cause is that some date of Time(Adj) are 12/31 but all date in Time(Time) are 12/30.
Best Regards,
Herbert
Please create a new column in Time table with following formual.
Time_Format = FORMAT ( 'Time'[Time], "Long Time" )
Then update the Shift column formula as below. It should can resolve the problem.
Shift = LOOKUPVALUE ( Time[Shift], 'Time'[Time_Format], FORMAT( Yearly[Time(Adj)], "Long Time" ) )
The root cause is that some date of Time(Adj) are 12/31 but all date in Time(Time) are 12/30.
Best Regards,
Herbert
Thank you very much! Works like a charm!