Forum Discussion

bigfun's avatar
bigfun
Icon for Helper I rankHelper I
4 years ago
Solved

Previous Month % in Card

So I am wanting to create a card that displays the previous months retention % based on the current date. Do I need to create another measure that calculates the % again with the DAX previousmonth f...
Need Help
Show and Tell
  • Syk's avatar
    Syk
    4 years ago

    If it will always just be for the previous month you can put a date filter on your card to show "Last 1 calendar month" with your current measure.

     

bigfun's avatar
bigfun
Icon for Helper I rankHelper I
4 years ago

Retention Pct = DIVIDE([MAU-Amt],[Cumulative NewUsers])

 

Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
4 years ago

The result you're getting in the card is  MAU_Amt / New Users. How are you calculating the Cumulative New Users?

  • bigfun's avatar
    bigfun
    Icon for Helper I rankHelper I
    4 years ago
    Cumulative NewUsers = calculate([New_Users],FILTER(ALLSELECTED('Calendar'[Date]),'Calendar'[Date] <= MAX('Calendar'[Date])))

    I also have a link to the .pbix if that helps too 🙂