Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Quarter over Quarter - Data Comparison

Hello! Thank you so much in advance for your time on this post.   I have a chart that shows the count of engaged users over time. I wanted to do a PoP (Period over Period) comparison. To facilitate...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago
    Hi
     
    Add a condition to the measure, if the “Count of users” is a measure,
    measure= IF([Count of users]>0, CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH)),BLANK())
     
    If the “Count of users” is a column,
    measure= IF(MAX ([Count of users])>0, CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH)),BLANK())
     
    Or
    Create a calculated column instead of a measure with the following formula.
    column= CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH))
    But a calculated column can’t change with any slicer.
     
     
    Best Regards
    Maggie
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago
Hi
 
Add a condition to the measure, if the “Count of users” is a measure,
measure= IF([Count of users]>0, CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH)),BLANK())
 
If the “Count of users” is a column,
measure= IF(MAX ([Count of users])>0, CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH)),BLANK())
 
Or
Create a calculated column instead of a measure with the following formula.
column= CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH))
But a calculated column can’t change with any slicer.
 
 
Best Regards
Maggie
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks a lot for your help :)