Forum Discussion

HusseinKhalil's avatar
HusseinKhalil
Icon for Helper I rankHelper I
6 years ago
Solved

Last non blank cell and return column header

I am trying to figure out how to allocate the last non blank cell in a row, then return the column header, this is using dax. i am dealing with a spread sheet which milestones are stored in the column headers and rows full of dates as below. Results should appear as per the last column

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try something like

    Switch( true(),
not(isblank([Customer Received Actual])),"Customer Received Actual",
not(isblank([Customer Received forecast])),"Customer Received forecast",
not(isblank([Deilvery Actual])),"Deilvery Actual",
not(isblank([Deilvery Received forecast])),"Deilvery forecast",
not(isblank([Shipping Actual])),"Shipping Actual",
"Shipping forecast")

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Try something like

    Switch( true(),
not(isblank([Customer Received Actual])),"Customer Received Actual",
not(isblank([Customer Received forecast])),"Customer Received forecast",
not(isblank([Deilvery Actual])),"Deilvery Actual",
not(isblank([Deilvery Received forecast])),"Deilvery forecast",
not(isblank([Shipping Actual])),"Shipping Actual",
"Shipping forecast")