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,
I've been searching through the other examples but nothing is exactly like my example so I'm posting here.
This is my dataset:
I'm trying to create a cross-tab of date by absence rate : ('Hours Lost'/'Total Time Available'). Drill-able on absence unit.
Q's
1. Is this possible?
2. If so how can this be done?
Thanks
Solved! Go to Solution.
Hi @stuartm,
#1, Yes, it is possible.
#2, You can try to use below formula if it suitable for your scenario.
Measure = CALCULATE ( SUM ( Table[Hours Lost] ) / SUM ( Table[Total time Available] ), VALUES ( Table[Date] ), VALUES ( Table[Category Column] ) )
Notice: Please use your category column to replace bold part.
Regards,
Xiaoxin Sheng
Hi @stuartm,
#1, Yes, it is possible.
#2, You can try to use below formula if it suitable for your scenario.
Measure = CALCULATE ( SUM ( Table[Hours Lost] ) / SUM ( Table[Total time Available] ), VALUES ( Table[Date] ), VALUES ( Table[Category Column] ) )
Notice: Please use your category column to replace bold part.
Regards,
Xiaoxin Sheng
xie xie nin. wo shi yi shi.
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 |