Forum Discussion

viferenc's avatar
viferenc
Icon for Helper II rankHelper II
5 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
    5 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]
)



     

viferenc's avatar
viferenc
Icon for Helper II rankHelper II
5 years ago

Each row represents a product and the row shows the monthly development of the cost of sales.

YukiK's avatar
YukiK
Icon for Impactful Individual rankImpactful Individual
5 years ago

Not sure how big of your table is, but I'd unpivot it so that the table will have product, month, and value (COS) columns. And from there, you'd be able to leverage functions like FIRSTNONBLANK() and LASTNONBLANK(). If you have sample data to share, I could further investigate what should be done.

 

Hope this helps!