Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Sales measure where the dates are unevenly spaced. How can I create a KPI where the first measure is the sales of the current selection date and the second measure is the sales of the previous report date, conditional on the current selection date?
Thank you.
Create an id for each of the period you wish to view the KPI and apply your condition based on the ID
Hi Santhosh. Okay, I've created ID for each date. How can I create condition based on them? Thanks.
Current Period:
Sum({<PeriodID={$(=Max(PeriodID))} >}Measure)
Previous Period:
Sum({<PeriodID={$(=Max(PeriodID)-1)} >}Measure)