Forum Discussion
Converting Aggregated data to Daily
I am doing some analysis on Covid 19 cases . The problem is my data set does not show new cases each day but the total cases accumulated to date. To Identify the incremental increase in cases each...
Anonymous try changing MAX to SUM, maybe there are two transactions on the same day
Today Cases = SUM('Daily Covid -19 Tracker'[Sum of total_cases]) - CALCULATE(SUM('Daily Covid -19 Tracker'[Sum of total_cases]), FILTER(ALL('Daily Covid -19 Tracker'), 'Daily Covid -19 Tracker'[date] = MAX('Daily Covid -19 Tracker'[date]) -1) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k
Super User
Super UserAnonymous try changing MAX to SUM, maybe there are two transactions on the same day
Today Cases =
SUM('Daily Covid -19 Tracker'[Sum of total_cases]) -
CALCULATE(SUM('Daily Covid -19 Tracker'[Sum of total_cases]), FILTER(ALL('Daily Covid -19 Tracker'), 'Daily Covid -19 Tracker'[date] = MAX('Daily Covid -19 Tracker'[date]) -1) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!