Forum Discussion

MarianaBotelho's avatar
MarianaBotelho
Microsoft Employee
10 years ago

Divide row by row

Hi guys, I've been having a little problem doing some math. I have the following table Time            Banana  Apple 1300-1305    1000      50 1305-1310    2000      30 1310-1315    3000      10...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

MarianaBotelho

 

According to your description, you want to change the 5 minutes slicers into 1 hour slicers. Right?

 

In this scenario, you can create calcualted column for getting the Hour part from each 5 minutes slicer. The DAX can be like:

 

Hour = IF(LEFT(Table[Time],2)=left(RIGHT(Table[Time],4),2),left(RIGHT(Table[Time],4),2),LEFT(Table[Time],2))

 

 

Then you only need to drag Hour, Banana and Apply column into table visual. It will aggregate on Hour level automatically. Then you can use measure formula as sdjensen suggested.

 

Ratio = 
SUMX(
	Table1,
	DIVIDE( CALCULATE( SUM(Table[Banana]) ), CALCULATE( SUM(Table[Apple]) ) )
)

Regards,

 

MarianaBotelho's avatar
MarianaBotelho
Microsoft Employee
10 years ago

First, I'd like to thank all the answers. Second, I'd like to appologize, because I'm not making myself understandeable. I'll try again.

 

I have the following table:

 

With this table, I need to generate a chart, that show two stacked (Banana and Apple) columns, the first with the sum of the data from 07/02 and the second with the sum of the data from 07/03.

Something like this:

 

 Did I made myself understandeable this time?

 

Cheers!