cpbwg Member

When we do DATEFIFF, it yields a "blue" dimension beast mode calculation and not a "green" Measure calculation. This is problematic because we want to do alerts based on the measure, but it doesn't offer the ability to alert (or do a summary number) because it's not a measure. Seems like a bug? Anyone know a workaround to…

I figured so. When I do the unnesting, I’m left with key-value pairs and a join key. I’m used to having to expand out horizontally to do analysis by columns…. It assuming things are row-repeats with different key-value pairs - do you have some insights or anything to share for how to analyze key-value data instead of…