Forum Discussion
Green_Cloud
Helper I
Helper IWeekly Running Total and Transformation Rate based on Two Measures
From the data source below, how can I build a report given that- Ad count=COUNT (adddate) Sales count= COUNT(salesdate) Report and Data Source are below- REPORT: DATA SOURCE: ...
Hi, Green_Cloud ;
Change it.
countstart = CALCULATE(COUNT('Table'[unique id]),FILTER('Table',[addate]<=MAX('Date'[weekend])))countend = CALCULATE(COUNT('Table'[unique id]),FILTER('Table',[saledate]<=MAX('Date'[weekend])))rate = [countend]/[countstart]The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yalanwu-msft
Community Support
Community SupportHi, Green_Cloud ;
1.create a table.
Date =
ADDCOLUMNS( FILTER( CALENDAR(DATE(2021,12,31),TODAY()) ,WEEKDAY([Date]+2,1) =1),"weeknum",WEEKNUM([Date]+2,1)-1,"weekend",[Date]+6 )2.create measures.
countstart = CALCULATE(COUNT('Table'[unique id]),FILTER('Table',[addate]<=MAX('Date'[weekstart])))countend = CALCULATE(COUNT('Table'[unique id]),FILTER('Table',[saledate]<=MAX('Date'[weekend])))The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Green_CloudThanks for the response. But, the expected output is as follows as we need to find the cummulative number of both measures (adcount and sales count) and corresponding transformation rate (salescount/ adcount) each week: