Forum Discussion

jaymetbar's avatar
jaymetbar
Frequent Visitor
6 years ago
Solved

Need help modifying a production number based on other data points

New to Power BI and I am trying to generate reports based on our production cells. I am ultimately trying to piece together something more complicated than this, but I am stuck at this current point ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

    Column = 
    VAR __Vessel1Value = MAXX(FILTER('Table',[Vessel Number] = 1 && [Production Date] = EARLIER('Table'[Production Date])),[Production])
    VAR __Count = COUNTROWS(FILTER('Table',[Vessel Number] <> 1 && [Production Date] = EARLIER('Table'[Production Date])))
RETURN
    [Production] - __Vessel1Value / __Count
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Perhaps:

 

Column = 
    VAR __Vessel1Value = MAXX(FILTER('Table',[Vessel Number] = 1 && [Production Date] = EARLIER('Table'[Production Date])),[Production])
    VAR __Count = COUNTROWS(FILTER('Table',[Vessel Number] <> 1 && [Production Date] = EARLIER('Table'[Production Date])))
RETURN
    [Production] - __Vessel1Value / __Count
jaymetbar's avatar
jaymetbar
Frequent Visitor
6 years ago

amazing. Thanks so much!