Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |