Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi. I have a straight set of data. In my query i have a calculated column Gross Profit and a calculated column for GP%. Then i bring the table in and have option to select say 2 months then it adds th % and not keep it per line
Solved! Go to Solution.
Create a new Measure and NOT a Column and add this formula:
Measure = divide(SUM(ACT[GPROFIT]),SUM(ACT[NSV]),0)
How do i share the file?
Share it through a dropbox link or upload it to a website and share it with us (e.g. wetransfer.com)
What email address do i add in wetransfer?
thanks
Create a new Measure and NOT a Column and add this formula:
Measure = divide(SUM(ACT[GPROFIT]),SUM(ACT[NSV]),0)
What is the formula that you are using? Any chance to share the workbook with us?
Mask any sensitive data
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |