Forum Discussion
Issue in getting Last day value for months
I have a table with Database name and its size for every day My monthly visualization report shows summation of all daily values instead of just last day value Tried Lastest measure as suggested bu...
Thank you. Please find two dates data for a few months for two databases. Hope this helpls
DATE SIZE DB
2/28/2019 82298235897 /h/d/acxiom_d2.db
2/27/2019 69319379088 /h/d/acxiom_d2.db
3/12/2019 97253210737 /h/d/acxiom_d2.db
3/11/2019 88956890579 /h/d/acxiom_d2.db
1/30/2019 59873497629 /h/d/acxiom_d2.db
1/29/2019 53114341773 /h/d/acxiom_d2.db
2/28/2019 321013903444 /h/d/brri_d2.db
2/27/2019 301910611943 /h/d/brri_d2.db
3/12/2019 521906815029 /h/d/brri_d2.db
3/11/2019 422353275041 /h/d/brri_d2.db
1/30/2019 252799734384 /h/d/brri_d2.db
1/29/2019 223246188600 /h/d/brri_d2.db
tarunsingla
Solution Sage
Solution SageCreate a calculated measure:
Latest Size =
VAR LastDateOfTheMonth = ENDOFMONTH(VALUES(TableName[DATE]))
RETURN CALCULATE (SELECTEDVALUE (TableName[SIZE]), TableName[DATE] = LastDateOfTheMonth)
Hope this helps.
Regards,
Tarun