Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |