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 colum...
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")
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")