previous day on text

[Broly]

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

[Ashish_Mathur]

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]

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

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[Broly]

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

[FreemanZ]

try this:

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