Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Daily Transactions Bypassing Dates

The goal is to calculate sales across all dates regardless if the sales occurred on that date or not. Currently, I am calculating sales that occurred on the date of the transaction (ex: "current_sale...
Need Help
Tutorial Requests
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi Anonymous ，

    IF you want to create a new coulumn to calculate output,use the following:

    out1 = SUM('Table'[current_sales_output])/COUNTROWS('Table')

    And if you want to create a measure to calculate it ,use the following :

    out2 = CALCULATE(SUM('Table'[current_sales_output])/COUNTROWS('Table'),ALL('Table'))

    Final output:

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

Why 5 for each non-total row? You want to show the average sales?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    AlexisOlson I chose 5 for each non-total row because it was divisible by 7 (as in 7 days). I could have chosen a better number but the goal of my example was to show an example that would be simple and easy to understand. Apologies if it is confusing. 

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      5 years ago

      I'm asking what it represents since 5 is clearly not the total across all dates that you are asking for in your original post but rather the total distributed equally across the dates (which you never mentioned as far as I can tell).

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        AlexisOlson The 5 represents the equal distributed total from the sample total of 35 across all of the dates. Ultimately, the business requirements is to look at sales over each quarter. I am replicating a report that was already created which had a calculated column dividing total sales / 90 days. 

         

        Please let me know if this can help or is still confusing.