Forum Discussion

Broly's avatar
Broly
Frequent Visitor
3 years ago

previous day on text

I have a table as follow :

Please keep in mind that I dont have a date column in the table but I use a date table.

 

I want to create a measure to get the previous day supply scheme.

 

When I use the "previousday()" function to get the previous day quantity, it works fine. 

I actually use this formula and it works fine as well : 

Qty previousday = CALCULATE(SUM(Table[quantity),FILTER ( ALL ( 'Date Table' ), 'Date Table'[Date] = MAX('Date Table'[Date]) - 1 ))
 
Problem is now I want to get the previous day supply scheme. Any easy way of doing this ?
 
Thanks for you help
Need Help
Tutorial Requests

5 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    try this:

     

    Supply scheme previousday = CALCULATETABLE(ALL('Table'[supply scheme]),FILTER ( ALL ( 'Date Table' ), 'Date Table'[Date] = MAX('Date Table'[Date]) - 1 ))

     

  • Broly's avatar
    Broly
    Frequent Visitor
    3 years ago

    thank you for your response. I was looking to create a measure for that since I'm in a live connection model

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    You say that you do not have a Date column in your table but i clearly see a Date column there.  Please clarify.

    • Broly's avatar
      Broly
      Frequent Visitor
      3 years ago

      the date comes from another table that has a relationship with the first table. In the first table I have the date but as a number format. Let me know if you need more details