Forum Discussion
Calculate daily maximums across filtered data
If you already have your Total Sales measure then you can calculate the maximum daily amount with
Daily max sales = MAXX ( VALUES ( 'Date'[Date] ), [Total Sales] )Should work at any level of the date hierarchy.
For future reference, when people want to share PBIX files they tend to use a file sharing site like Dropbox or We Transfer, or else share directly from something like Google Drive or OneDrive.
Super UserIf you already have your Total Sales measure then you can calculate the maximum daily amount with
Daily max sales =
MAXX ( VALUES ( 'Date'[Date] ), [Total Sales] )
Should work at any level of the date hierarchy.
For future reference, when people want to share PBIX files they tend to use a file sharing site like Dropbox or We Transfer, or else share directly from something like Google Drive or OneDrive.
Legend, thank you! I've spent days Googling around for solutions and trying needlessly complex things, I knew it would be something much more simple.