Last date with a value

[Saud19999]

Hey there,,

here is my table below,,

I want to compare my last available value in the table with the previous one,

Thanks,,

[Saud19999]

sorry didn't work ,,, here is a sample data 

sample data.pbix

[Ashish_Mathur]

Hi,

Show the exact result that you are expecting.  Also, share the download link of the PBI file.

[Saud19999]

I didn't get any results so far,, 

I need a bar that displays the last and the previous values with a different percentage.

Day Month Sum of Value
1 May 6,927,633
2 May 6,730,973
3 May 6,921,894
4 May 6,882,067
5 May 6,830,516
6 May 6,864,411
7 May 6,921,897
8 May 6,888,335
9 May 6,808,630
10 May 6,729,808
11 May 6,851,490
12 May 6,665,045
13 May 6,734,506
14 May 6,790,604
15 May 6,985,259
16 May 7,019,464
17 May 6,978,842
18 May 7,115,563
19 May 7,060,486
20 May 7,109,409
21 May (Blank)
22 May (Blank)
23 May (Blank)
24 May (Blank)
25 May (Blank)
26 May (Blank)
27 May (Blank)
28 May (Blank)
29 May (Blank)
30 May (Blank)
31 May (Blank)

[Ashish_Mathur]

Hi,

To your visual, drag Month and Year from the Calendar Table.  Write these measures

Total = sum(Data[sales])

Total on previous day = calculate([total],previousday(calendar[date]))

Growth over previous day (%) = divide(([Total]-[Total on previous day]),[Total on previous day])

Hope this helps.

[Ashish_Mathur]

I still do not know the result that you want.

[Saud19999]

thank you for your cooperation,

I want a graph that compares the last value with the previous one, given a date table.

then I want to find the difference by percentage.

[Greg_Deckler]

@Saud19999 See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
  __Current - __Previous