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



     

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

What does each row represent? I was thinking we can upivot the columns into rows, and use something like FIRSTNONBLANK() function. The way the table is set up doesn't seem to be the best way to handle this

  • 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!