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 guys,
I have a table with the sample like this:
Date | Customer |
1/1/2015 | A |
1/1/2015 | B |
1/1/2015 | C |
1/1/2015 | D |
1/1/2015 | E |
1/1/2015 | F |
1/1/2015 | G |
1/1/2015 | H |
2/1/2015 | A |
2/1/2015 | B |
2/1/2015 | D |
2/1/2015 | E |
2/1/2015 | F |
2/1/2015 | C |
2/1/2015 | I |
2/1/2015 | J |
2/1/2015 | K |
2/1/2015 | L |
2/1/2015 | M |
2/1/2015 | N |
3/1/2015 | A |
3/1/2015 | B |
3/1/2015 | C |
3/1/2015 | E |
3/1/2015 | D |
3/1/2015 | F |
3/1/2015 | G |
3/1/2015 | H |
3/1/2015 | I |
3/1/2015 | J |
4/1/2015 | A |
4/1/2015 | B |
4/1/2015 | C |
4/1/2015 | D |
4/1/2015 | E |
4/1/2015 | F |
I wanted to create a calculated column with this formula:
"Prev12Members = CALCULATE(DISTINCTCOUNT(Table[Customer]), SAMEPERIODLASTYEAR(Table[Date]))"
However, it does not result in any values. It worked when I tried creating a measure and created a table (Visualization) with Date & this measure. Just wonder if it is possible to create calculated column as mentioned? Any insight will be greatly appreciated! Thanks!
Regards,
Henry
Solved! Go to Solution.
Hi,
Try this formula
=CALCULATE( AVERAGEX(VALUES(Customer[Date]), [Churn Rate]), DATESBETWEEN ( Customer[Date], EDATE(MIN(Customer[Date]),-11),MAX(Customer[Date])))
Hope this helps.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |