Forum Discussion
Anonymous
5 years agoNot applicable
Divide values in a line chart
Hello, I have 2 tables and I would want to divide the values per month. Take note that these values are found in the same table but different metrics type. 1st table has the Metric type Depl...
amitchandak
Super User
5 years agoAnonymous , They need to joined with coomon date table then you can do like
divide([Deployment], [P1 & P2])
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.