Forum Discussion

gauravp's avatar
gauravp
Regular Visitor
8 years ago
Solved

Calculating Parts per Thousand

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.

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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.

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    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.