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
grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
1 year ago

Could you please share sample data, along with your expected result and any relevant logic.

If possible, upload a simplified .pbix file using this guide:

 How to upload PBI in Community

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

I have attached a sample PBIX file along with the expected results.

 

 

Excel 

Sample File 

  • 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