topic Re: Remove Maximum Cohort Period from MonthYear Row in DAX Commands and Tips

Remove Maximum Cohort Period from MonthYear Row

BICrazy — Fri, 11 Sep 2020 14:05:40 GMT

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.

Re: Remove Maximum Cohort Period from MonthYear Row

Greg_Deckler — Fri, 11 Sep 2020 14:11:13 GMT

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)

Re: Remove Maximum Cohort Period from MonthYear Row

amitchandak — Fri, 11 Sep 2020 14:19:02 GMT

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]))

Re: Remove Maximum Cohort Period from MonthYear Row

Fowmy — Fri, 11 Sep 2020 14:53:49 GMT

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 🙂

YouTube LinkedIn

Re: Remove Maximum Cohort Period from MonthYear Row

BICrazy — Sat, 12 Sep 2020 13:41:41 GMT

Fowmy , amitchandak , Greg_Deckler

All of the measures you guys proposed worked in my case. Thanks a mill for your help.

Re: Remove Maximum Cohort Period from MonthYear Row

Greg_Deckler — Sat, 12 Sep 2020 17:49:47 GMT

BICrazy Always more than 1 way to do things in DAX!!