Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Total Completed Orders

Hello,    I have a bit of an issue I'm not quite sure how to handle. I have a table that has Order # / Order Description / Created Date and Completed Date. The problem, is I need to be able to accu...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Anonymous

     

    One approach is to add the following calculated column to your table.

     

    This will bucket each order into a month.  If you use this new column on the axis of a visual, you can then drop a Count of Orders measure into the values to give you an accurate picture.

     

    CompletedMonth = DATE(
                YEAR('Table'[CompletedDate]) ,
                MONTH('Table'[CompletedDate]) ,
                1
            )
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

One approach is to add the following calculated column to your table.

 

This will bucket each order into a month.  If you use this new column on the axis of a visual, you can then drop a Count of Orders measure into the values to give you an accurate picture.

 

CompletedMonth = DATE(
                YEAR('Table'[CompletedDate]) ,
                MONTH('Table'[CompletedDate]) ,
                1
            )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Awesome! Was able to add the column and filter by date and other desired fields! Thank you both for the replies. Big help!