Skip to Content
0
Former Member
Apr 29, 2014 at 12:24 PM

Best Practise comparing measure with historic data?

20 Views

Hello everyone,

we are currently trying to compare a measure for a certain week with the same measure of the weeks before. To make a condition such as: "If number of alerts in the 3 previous weeks > 100 then 1 else 0 [for this specific week]".

However we are struggling because it seems that Measures and Dimensions are strictly separated from each other. "number of alerts" would be a measure, "week" would be a dimension. When creating a measure only other measures are available in the formula creator, when creating a dimension only other dimensions are available. In our understanding we would have a formula with both measures and dimensions in it.

Any suggestions?

Thanks in advance!

Marvin