Forum Discussion
Solved
How to order by weeks (chronologically)
Hello everyone. I have little time using Power BI and I am still adapting to the tool. I'm modeling data to show the total number of organizations for each of the stages in my sales process...
Hi Victor_1706,
I created one measure to get the count of days per organization.
Measure = VAR mindate = CALCULATE ( MIN ( deals[Último cambio de etapa] ), ALLEXCEPT ( deals, deals[Etapa] ) ) VAR maxdate = CALCULATE ( MAX ( deals[Último cambio de etapa] ), ALLEXCEPT ( deals, deals[Etapa] ) ) RETURN DATEDIFF ( mindate, maxdate, DAY )For more details, please check the pbix as attached.
Regards,
Frank
Hi Victor_1706,
Which column is the code? You can update the formula to it.
Measure = VAR mindate = CALCULATE ( MIN ( deals[Último cambio de etapa] ), ALLEXCEPT ( deals, deals[Etapa],deals[code] ) ) VAR maxdate = CALCULATE ( MAX ( deals[Último cambio de etapa] ), ALLEXCEPT ( deals, deals[Etapa],deals[code] ) ) RETURN DATEDIFF ( mindate, maxdate, DAY )Regards,
Frank
Hi, v-frfei-msft, sorry for the absence...
The measure doesn't count per organizations, it only counts by "Etapa" but, it's nice... So thanks for help.
Only one cuestion more:
- May I change or modify the code to count the days per Organizatios whit the same code?
Best regards,
Victor.
Hi Victor_1706,
Which column is the code? You can update the formula to it.
Measure =
VAR mindate =
CALCULATE (
MIN ( deals[Último cambio de etapa] ),
ALLEXCEPT ( deals, deals[Etapa],deals[code] )
)
VAR maxdate =
CALCULATE (
MAX ( deals[Último cambio de etapa] ),
ALLEXCEPT ( deals, deals[Etapa],deals[code] )
)
RETURN
DATEDIFF ( mindate, maxdate, DAY )
Regards,
Frank