Forum Discussion
Max month in table with data
Hi, TravisGlanzer
Try measure as below:
Qtr_monthno = RANKX ( FILTER ( ALL ( 'BdgDate' ), BdgDate[Quarter] = MAX ( BdgDate[Quarter] ) ), CALCULATE ( MAX ( BdgDate[Date] ) ), , ASC ) //Rank of month in each quarterMax_Qtr.No = MAXX ( FILTER ( BdgDate, ( BdgDate[Quarter] = MAX ( BdgDate[Quarter] ) && [ReportBuilderEntCurrentDonorBase] <> BLANK () ) ), [Qtr_monthno] ) //max month where data exists for actualsResult = CALCULATE ( MAX ( 'VW_AGGR_DONOR_BASE'[Donor Base] ), FILTER ( ALL ( BdgDate ), ( BdgDate[Quarter] = MAX ( BdgDate[Quarter] ) ) && [Max_Qtr.No] = MAXX ( BdgDate, [Max_Qtr.No] ) ) )Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, TravisGlanzer
For the missing value of future budget in picture, you can take a try to add "+0" in the end of your measure "Report Builder Actual" and "Reprot Build Budget".
If it doesn't work, please share the sample pbix file for further research.
Best Regards,
Community Support Team _ Eason
Thanks for the response. Didn't get the +0 to work. here is the sample file. You can see I do not have a 2Q result for Current because the last result was in May which is the nmber I would like to represent for the quarter. https://vitalant-my.sharepoint.com/:u:/g/personal/009247_bloodsystems_org/EVfjm7Rl8nBLnCBGJkCZRdwBYNDoka3pBSki3yk0rIU18g?e=F9mNVe
Hope this works.
Hi, TravisGlanzer
It seems that I don’t have permission to access it.
Can you check the permission and share the link again?
Best Regards,
Community Support Team _ EasonDoesn't look like my company will let me give access to anyone with a link:
This site doesn't seem to allow me to just post the pbix?
