Forum Discussion

Vitor_sp_bo's avatar
Vitor_sp_bo
Helper I
4 years ago
Solved

Recurrence Product

Guys, all right? I have a dataset with 2 columns (Product Code, Date), I need to map the products that are recurring for example (today() and today()-1), the big problem is that I have 1 date per li...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Please consider this solution and click the thumbs up icon just for me taking the effort to helping you, and click accept the solutioin if it fixes your problem. Cheers !

     

    Reoccurs =
    var mydate = SELECTEDVALUE('Table'[Date])
    var prevdate = mydate - 1
    RETURN
    CALCULATE(
    COUNTROWS('Table'),
    'Table'[Date] = prevdate
    )
     
speedramps's avatar
speedramps
Super User
4 years ago

Please consider this solution and click the thumbs up icon just for me taking the effort to helping you, and click accept the solutioin if it fixes your problem. Cheers !

 

Reoccurs =
var mydate = SELECTEDVALUE('Table'[Date])
var prevdate = mydate - 1
RETURN
CALCULATE(
COUNTROWS('Table'),
'Table'[Date] = prevdate
)
 
  • Vitor_sp_bo's avatar
    Vitor_sp_bo
    Helper I
    4 years ago

    It didn't work, I need to count the products that were yesterday and today, so I need the two values ​​to define the recurrence

    • speedramps's avatar
      speedramps
      Super User
      4 years ago

      If you create a visual table with product and date then this measure will flag any product that has a record for the previous day.   I tested it ok
       

      Reoccurs =
      var mydate = SELECTEDVALUE('Table'[Date])
      var prevdate = mydate - 1
      RETURN
      CALCULATE(
      COUNTROWS('Table'),
      'Table'[Date] = prevdate
      )
       
      • Vitor_sp_bo's avatar
        Vitor_sp_bo
        Helper I
        4 years ago

        Okay, I need it to filter by product code, that way it would only evaluate the date, right?