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.
I'm trying to understand whether I have a calculation error, or have used Power BI incorrectly.
Here, I don't seem able to show data for past May, even though the filter on the right hand side indicates that there is data for June onwards (2020-06 and so on). I also notice the result is displayed as (blank) in the table, as opposed to 0.0 for 1970-01, for example.
Is there some glaringly obvious mistake that I've made, or is it likely to be the calculation?
Thank you both.
The calculation I'm using is:
And how is [Current CM Sum] defined?
It's a measure (SUM) of a column with a set value (calculated at the data source and loaded into Power BI).
I think I've figured out my own mistake, at least partially. I'm wanting to look at deals that are closing at a particular date (e.g. "Sum of CM for all deals closing in October), but when I multiply this with the closing probability, the latter should be unfiltered ("number of deals won out of all deals created in the past").
@enorberg , something to do with formula, can you share that
@enorberg - It's really difficult to say with the information provided but I would guess calculation at this point.
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Covering 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |