Forum Discussion
GunnerJ
Post Patron
Post Patronrepeat row value for new column based on filter date
I have a row counter for each row by account. What I'm hoping to do is repeat the max value across all rows as long as that rows date field is less than the date filter. The filter is in the "before"...
This works in your pbix file.
MAX ROW = VAR vMAXDATE = MAX('Date Table'[Date]) RETURN CALCULATE( CALCULATE( MAX('MASTER CHARGE ACTIONS'[ROWRANK]), FILTER('MASTER CHARGE ACTIONS', 'MASTER CHARGE ACTIONS'[CHG_DATE] <= vMAXDATE) ), ALLEXCEPT('MASTER CHARGE ACTIONS','MASTER CHARGE ACTIONS'[BI_ACCT]))
Ashish_Mathur
Super User
Super UserHi,
Share the link from where i can download your PBI file.
GunnerJPost Patron
Post Patron
Here you go! It's in the state shown in the last picture.
https://www.dropbox.com/s/fgrcl590zb21xoh/OZARKSGO%202.0.pbix?dl=0