Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 but I am getting only only Latest month.

When I drill down lastest month, only last day of the month visible

I would  like to see all days data of that month.

While rolling up, all months should be seen

Would appreaciate any help to overcome this

 

Before  using Latest measure, all months summerrized data 

visual1.png

After "Latest" measure only Last available month and Last date on that month visual when drill down with correct value of the size.

 

visual2.png

Any help would be appreciated 

 

4 REPLIES 4
Anonymous
Not applicable

If you can provide some sample data that would help a lot.  This is one of those cases where it's probably a fairly simple fix based on how the visual is set up (sorting by months or days, for example) - but without sample data or extra information, it's tough to diagnose exactly what to recommend as a fix.

Anonymous
Not applicable

output.png

 

Thanks for the response. This is measure gave me what is required for month end but populating other rows with last month month data instead of daily data. Attaching output for your reference. Am I missing anything here?

 

Thanks & Regards

-BSadagopan

Anonymous
Not applicable

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

Create a calculated measure:

 

Latest Size =
VAR LastDateOfTheMonth = ENDOFMONTH(VALUES(TableName[DATE]))
RETURN CALCULATE (SELECTEDVALUE (TableName[SIZE]), TableName[DATE] = LastDateOfTheMonth)
 
Hope this helps.
 
Regards,
Tarun

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.