Skip to Content
author's profile photo Former Member
Former Member

Conditional Calculated Measure

The raw data that I am pulling into Lumira has a YTD sum of units sold as one of the measures. This data is published quarterly. What I want to do in Lumira is:

adjusted qty = If quartermonth = 12 then qty(quartermonth(12)) - qty(quartermonth(9))

What I'm getting at is having Lumira calculate the quarter's actual quantity instead of the running sum that it is giving me.

Add comment
10|10000 characters needed characters exceeded

0 Answers