Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JessicaM
Frequent Visitor

Calculate number of 2 months ago in a KPI

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!

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@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
Super User
Super User

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.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors