Forum Discussion

viferenc's avatar
viferenc
Helper II
4 years ago
Solved

Take the first data entry from specific columns

Dear All,   I would like to ask for your help, becasue I was not able to figure out how the following issue could be solved with DAX formula.    I have the table below (the table has several othe...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    viferenc 

    Agree with YukiK , unpivoting and building your model would be the best approach but if you want to do the calculation based on your existing model, then add a new column to your table as I have shown in the example below, I added just three months but you can include all 12 months.

    1st Value = 
DIVIDE(
    FIRSTNONBLANK( {[Oct COS],[Nov COS],[Dec COS]} , [Value] ),
    [Dec COS]
)



     

Fowmy's avatar
Fowmy
Super User
4 years ago

viferenc 

Agree with YukiK , unpivoting and building your model would be the best approach but if you want to do the calculation based on your existing model, then add a new column to your table as I have shown in the example below, I added just three months but you can include all 12 months.

1st Value = 
DIVIDE(
    FIRSTNONBLANK( {[Oct COS],[Nov COS],[Dec COS]} , [Value] ),
    [Dec COS]
)