Previous Value in Measure for Next Column in Matrix Table

[Anonymous]

Hi Experts,

I am finding an issue to get the result below. Attached is the data set.

Please help me. 

Attaching the .pbix file.

Invoiced Amount = Total Amount Based on Customer Number for the current Date and for future dates it should display Closing value of the previous date (As per the below screenshot)

Please suggest any DAX changes are any modeling changes that need to be applied.

[Anonymous]

Please someone help me on this data issue??

[amitchandak]

@Anonymous , With help from date table, You can create measures liek example and in matrix you have use "Show on row"

example

This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))

Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))

Show on row : https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Help me how to upload the .pbix file here?

[Anonymous]

https://drive.google.com/file/d/1khHKtct-Fa4cDTFVHfH5Z_BIS6ecfxv8/view?usp=sharing

Link to download .pbix file