Toronto Power BI, Power Apps, Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
  • 1.  using a expiry date

    Posted Nov 02, 2021 09:53 AM
    i am trying  to use an expiry date in a bi report.
    the concept  is  live product is harvested on Aug 13/21, 9651 units,
    Purchase Order for  150 units,
    balance Balance held  in Cooler  9501
    Out_Date  20/08/21  (7 days )
    Toss column should show the same amount as what is held in the cooler.
    cooler amount should be decreased to 0.

    any suggestions would be greatly appreciated. thanks

    Frank Fenton
    IT Development Manager
    Bayview Flowers
    jordan station ON

  • 2.  RE: using a expiry date

    Posted Nov 03, 2021 08:38 AM


    I would think a couple of measures would be all that is needed. Or am I not understanding the requirement?


    Cooler Amount = IF TODAY() < [Out_Date] ,[Cooler],0

    Toss Amount  = IF TODAY() <  [Out_Date] ,0,[Cooler]

    Rick Gosden
    Systems Analyst