Forum Discussion
o59393
Post Prodigy
Post ProdigySummarize various calculate functions into one
Hi all I created 8 dax function that returns the count of ocassions the "Government time" is within: 0 - 30 days 30 - 60 days 60 - 90 days 90 - 120 days 120 - 150 days 150 - 180 days 1...
Hi
try this file https://ufile.io/whlx43iq
I added dimension table dimIntervals with all possible intervals and a calculated column in your table
Interval = calculate(FIRSTNONBLANK(dimIntervals[Label];1); FILTER(ALL(dimIntervals); dimIntervals[MinPeriod] < 'Sanitary Registration Mass Report'[Cycle Time (Process)] && dimIntervals[MaxPeriod]>='Sanitary Registration Mass Report'[Cycle Time (Process)]) ) You are welcome. If my previous reply helped, please mark that as Answer.
ABCD is just the title of the column. You may give any meaningful title within the double quotes.
az38
Community Champion
Community ChampionHi
try this file https://ufile.io/whlx43iq
I added dimension table dimIntervals with all possible intervals and a calculated column in your table
Interval = calculate(FIRSTNONBLANK(dimIntervals[Label];1); FILTER(ALL(dimIntervals); dimIntervals[MinPeriod] < 'Sanitary Registration Mass Report'[Cycle Time (Process)] && dimIntervals[MaxPeriod]>='Sanitary Registration Mass Report'[Cycle Time (Process)]) )
