Calculating Parts per Thousand

[gauravp]

Hi All, 

I have a column which has date for each product and another column which has some values like Class A, Class B etc. I want to calculate Total number of Class A/ Total number of products in each month *1000. It would be really helpful if you could please let me know. Thank you in advance.

[Phil_Seamark · Accepted solution]

Hi @gauravp

One way to do it is to add a column to your table that groups each product date to the start of each month.  Then you can just drag the new column to a visual along with a COUNT measure that includes a *1000 adjustment.