Daily growth of values

[abukapsoun]

Hi Experts,

I am somehow newbie, and need your expertise to find the day to day growth of my dataset. 

Date	Time	Catergory	Value
09 Nov	XX	Cat1	600
09 Nov	YY	Cat1	300
09 Nov	ZZ	Cat1	800
10 Nov	...	Cat2	100
10 Nov	...	Cat2	452
10 Nov	...	Cat2	536
10 Nov	...	Cat2	1234

I want to calculate the daily growth of the following: (Average of Cat1 values + average of Cat2 values)

Thank you very much 

[mangaus1111 · Accepted solution]

Hi @abukapsoun ,

see my pbi file

https://1drv.ms/u/s!Aj45jbu0mDVJi1KGdgX4lpYmrLDQ?e=aPc2hD

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abukapsoun]

hi @mangaus1111 

Seeking your support one more time on that. I have a table with a column country and have values, and wants to check the same growth per country. I applied the same logic you have provided and got the below result. the left hand table is the one with real values per country. the right hand one, it has the growth. As you can see, the growth worked on the total value, but not per country. all countries are showing same total value. 

Can you maybe advise how I can fix that?

Thank you.

[abukapsoun]

I noticed one thing, if I put a filter on the side and select it country by country, i can see the value reflected correctly. but if i select more than 1 country, the data get messed up 

[abukapsoun]

Thank you very @mangaus1111 I am almost there reaching my purpose. 

There is only 1 thing that I would appreciate if you can help me further with. 

The values showing are the average of Cat1 or Cat2 or Cat1 and Cat2. While what I would like to display is the (AverageCat1 + AverageCat2). 

Would that be possible?

Thank you very much

[abukapsoun]

hi, I used calculate and could achieve it. Thank you

[abukapsoun]

Any advice please?

[amitchandak]

@abukapsoun , Join your date with date of date table, and then like below can help

This Day = sum('Table'[Value])

This Day = CALCULATE(sum('Table'[Value]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('Table'[Value]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('Table'[Value]), previousday('Date'[Date]))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[abukapsoun]

Hi @amitchandak 

How did you use two measures with same name? I am confused what am I supposed to do about it 

This Day = sum('Table'[Value])

This Day = CALCULATE(sum('Table'[Value]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))

[abukapsoun]

Sorry Amit but I didn't really get it. Is it possible to have it in pbix file?