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

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. 

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

OK. I'd suggest asking for what you're actually interested in achieving in your post. It's easy to remove all date filtering in a measure to return the total over all dates but that doesn't align with your specified output. I could write a measure that distributes the total over all dates but then I don't know if that's really what you want or if you actually want to distribute over each quarter separately or something else entirely.