Dax measurement of the previous day in matrix

[Anonymous]

Hello Community,

I've tried to figure out how to get my measure to show the previous day's sales for a specific customer.

I used this:

INV YDA - CALCULATE(SUM(Fact_Invoiced[TTL_EUR_AMOUNT]); PREVIOUSDAY(Dim_Calendar[Fecha]))

It works well when I'm using it on a table. There I can see that it is showing the correct results.

My problem occurs when I'm using the measurement in a matrix. Then, when I choose a specific month in a filter, the matrix will display the value of the 1st day of the selected month instead of the sales from the previous date of the month.

For example. Is there a way to get him to show 4/5 sales instead of 1/1 in the matrix? Maybe by adding some way a maximum date or something

[amitchandak]

@Anonymous , this seems fine, should have worked. Try this option with your date table

example

Last Day Non Continous = CALCULATE(sum('order'[Qty]),filter(all(Table),Table[Date] =MAXX(FILTER(all(Table),Table[Date]<max(Table[Date])),Table[Date])))
Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd(Table[Date],-1,Day))

[Anonymous · Accepted solution]

hi @amitchandak ,

Thanks for the quick response!

I checked your solution and couldt not get it to work on my data.

Instead I ended up creating another matrix with an istoday filter to show only the changes since yesterday and still kept the monthly invoice overview matrix.

[v-lionel-msft]

Hi @Anonymous ,

Please show us a sample data, such as Fact_Invoiced table and Dim_Calendar table.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.