Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear community,
i'd need your support as i'm trying to do - apparently - a very easy thing but ... i can't 🙂
I have a table loaded with 2 simple measures: count number of trips.
I created another simple measure which is the difference between the two columns.
So you see that's super easy. I would love to add a measure called Delta trip % which is basically the (Trip Actual / Trip Budget ) -1 and % format.
I then created this whici partially works
As you see, % is ok but the same table with new measure is creating :
i) first top blank line
ii) other line "not needed" such as INDIA and ROMANIA.
Any suggestion ?
thank you very much for your great support !
Solved! Go to Solution.
@PaulMcDk , Try like
divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank())
or
if(isblank([Trip Actual] ) || isblank([Trip Budget]), blank(), divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank()) )
@PaulMcDk , Try like
divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank())
or
if(isblank([Trip Actual] ) || isblank([Trip Budget]), blank(), divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank()) )
thanks!
first like did work
p
User | Count |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |