Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, everyone! I am trying to calculate the first response time as a calculated column, but I received a blank. I have added an example of my fact table and calculation that I have a problem to fix. I will appreciate any advice. Thanks.
Solved! Go to Solution.
Thank you for your response! I am trying to bring the calculation to the lookup table to do not create additional columns in the fact table. Would I be able to do it with Custom Column?
Great idea, thanks. Would I be able to do all the calculations with Custom Column in Power Query? Or maybe create intermediate columns to simplify calculation in Dax?
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |