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.
Ok gang,
Here's what I'm trying to do. I want to know the number of days using a column with date values, then get the average, then take teh # of days open and filter between specific day ranges (i.e. 30, 60, 90).
So ideally I want to take that column and calculate how many days from the [Date_Opened] to today. Then I'd like to calculate the average.
I did get
# of Days Open = datediff(MIN(tableS1[Date_Opened]),TODAY(),DAY)
and
Avg Days Open = CALCULATE(AVERAGEX(tableS1,[# of Days Open]),tableS1[Account])
then
120 Days = IF(tableS1[# of Days Open]<=120,DISTINCTCOUNT(tableS1[Account]),"") *here I figured that if there was an open account greater than 120, doing a distinctcount would sum up the number that filled that criteria.
So these return a value I think is right but I wanted to see if this was correct.
Another question is, if I get a good figure, will this work with a slicer?
Solved! Go to Solution.
Tough to say without sample data. Seems reasonable. And sure, if you create a column where you classify things into buckets like 120, 90 ,60 etc. then that will work in a slicer. I would do that and then all you need is a simple count aggregation to get you the number in each bucket.
Tough to say without sample data. Seems reasonable. And sure, if you create a column where you classify things into buckets like 120, 90 ,60 etc. then that will work in a slicer. I would do that and then all you need is a simple count aggregation to get you the number in each bucket.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |