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 function? Or something else.


I have the measures built to calculate the retention % by month (there is a little hiccup with Mar2021 data that will be resolved)


Link to the file

 

  • 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.

     

6 Replies

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar

    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

      That is simple enough, but when I apply that to the card for the visual the % does not match up with the table.


      I think it has to do with the measure, other values work out fine.

       

       

      • Syk's avatar
        Syk
        Icon for Resident Rockstar rankResident Rockstar

        What is your measure?