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]
)



     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi viferenc ,

 

You can create an index column and then create a measure similar to the following

 

Column = CALCULATE(MAX('Table'[Column1]),FILTER(ALL('Table'),[Index]=1))

 

 

How to add an index column:

https://docs.microsoft.com/en-us/power-query/add-index-column

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.