Forum Discussion

Amos_Lim's avatar
Amos_Lim
Icon for Resolver I rankResolver I
1 year ago

DAX Synex EARLIER Error

Hi,   My code keeps showing EARLIER/EARLIEST refers to an earlier row context which doesn't exist.. Any help would appreciate. Thanks.   Rank = RANKX(FILTER('ForkLiftData', 'ForkLiftData'[SAP N...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Show the expected result in another column of the Excel file.

Amos_Lim's avatar
Amos_Lim
Icon for Resolver I rankResolver I
1 year ago

The Excel file contained raw data for all users, including their Name, SAP Number, POC, Department, Forklift License Valid Until date, and the Forklifts they are authorized to operate.

I duplicated the sheet to illustrate the expected outcome in the Power BI dashboard.

Excel with Expected Result Sheet