Calculate number of 2 months ago in a KPI

[JessicaM]

Hi all!

I´m trying to calculate a KPI which will show the MRR so I would need:

Calculate the total accounts activated during last month

Calculalte the pay accounts during last month

I have columns where I can difference between Payer or not and I have also a Calendar table 

I tried with DATEADD, PREVIOUSMONTH, etc., always using the Calculate formula but it not working.

Somebody could give me a hand on that please?

Thanks!

[Anonymous]

@JessicaM 

It is not wrong using these functions. But it is depend on the your model and requirement. It would be best if you can just share a short sample data with fact table and calendar table using some random values due to data sensitivity.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @JessicaM ,

The information about your model and data is very scarse, please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.