Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show current month and previous month in separate visualizations.

Hi,

 

I have a scenario where I would like to display the value for current month in one data card and the value for previous month in another. I would like to be able to just apply the date in the Filter on all pages to update the entire Power Bi since this is a monthly report. The current month should display 0.55 (December) as it does below and the previous month should display 0.39 (November). I am not real sure how to go about solving this issue since and am willing to try whatever.

 

 

Thanks in advance for any help!

 

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    If your date column is contiguous dates,take below steps:

    Create a measure as below:

    Previous = CALCULATE(SUM('Table'[value]),DATEADD('Table'[date],-1,MONTH))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Otherwise,first create a calendar table as below:

    calendar = CALENDAR(MIN('Table'[date]),MAX('Table'[date]))

    And create a relationship between your table and calendar table;

    Then create a measure as below:

    _Previous = CALCULATE(SUM('Table'[value]),DATEADD('calendar'[Date],-1,MONTH))

     And you will see:

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    If your date column is contiguous dates,take below steps:

    Create a measure as below:

    Previous = CALCULATE(SUM('Table'[value]),DATEADD('Table'[date],-1,MONTH))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Otherwise,first create a calendar table as below:

    calendar = CALENDAR(MIN('Table'[date]),MAX('Table'[date]))

    And create a relationship between your table and calendar table;

    Then create a measure as below:

    _Previous = CALCULATE(SUM('Table'[value]),DATEADD('calendar'[Date],-1,MONTH))

     And you will see:

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!