Forum Discussion
Helper IIRemove Maximum Cohort Period from MonthYear Row
Hello fellow members,
Need help with a Measure to not display the maximum cohort period on each row per MonthYear on the following visual.
Example
MonthYear May-19 should stop at period 13
MonthYear June-19 should stop at period 13
MonthYear Jul-19 should stop at period 12 etc...
Therefore the measure should be Max period minus 1. Hope I'm clear enough. Thanks in advance.
BICrazy - I am thinking something like:
Measure VAR __Calc = <some calc> VAR __Period = MAX('Table'[Period] // whatever is in your Columns VAR __Num = COUNTROWS(ALL('Table'[Period]),[Period]>__Period RETURN IF(ISBLANK(__Num),BLANK(),__Calc)BICrazy , in your case these measure on top of you measure should work
if([Measure]=0, blank(), [measure]) or
sumx(values(Table[Monthyear]),if([Measure]=0, blank(), [measure]))
BICrazy
Include our measure within an IF condition like:Measure New = IF( SELECTEDVALUE(Table[Day])> 10 , BLANK() , [Your% Measure] )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
5 Replies
- Fowmy
Super User
BICrazy
Include our measure within an IF condition like:Measure New = IF( SELECTEDVALUE(Table[Day])> 10 , BLANK() , [Your% Measure] )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
- BICrazy
Fowmy , amitchandak , Greg_Deckler
All of the measures you guys proposed worked in my case. Thanks a mill for your help.- Greg_Deckler
Community Champion
BICrazy Always more than 1 way to do things in DAX!!
- Greg_Deckler
BICrazy - I am thinking something like:
Measure VAR __Calc = <some calc> VAR __Period = MAX('Table'[Period] // whatever is in your Columns VAR __Num = COUNTROWS(ALL('Table'[Period]),[Period]>__Period RETURN IF(ISBLANK(__Num),BLANK(),__Calc) - amitchandak
BICrazy , in your case these measure on top of you measure should work
if([Measure]=0, blank(), [measure]) or
sumx(values(Table[Monthyear]),if([Measure]=0, blank(), [measure]))
