Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a question that Google wasn't able to help with.
I need to write a DAX measure to calculate the number of days a product took for the revenue to match/surpass its cost.
Table.A has information for the product sold (date sold and revenue)
Table.B has the cost information.
Table.C has the date product was made available to sell.
Any ideas?
You may start from the code generated by Quick measure Running total.
@v-chuncz-msft Thanks for your reply.
I did try to use the quick measure but for some reason, the count (distinct) did not return the proper value. I'm trying again with calculated column and hope I can get this right now.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |