i create measure Potential GP = [DBD Traffic]*[Highest Rev/traffic] which i want to multiply with number of date days
for example, protenial trand = iferror([Potential GP]*[calender(days)],0)
how that will possible?
Go to Solution.
You could use this formula as below:
Measure = [Potential GP]* DAY(SELECTEDVALUE(calender[Date]))
Of course, you could nest them with other functions
View solution in original post
@v-lili6-msft thank you, its work
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!