Forum Discussion
vanessafvg
Community Champion
Community ChampionCummulative values issue when using inactive relationships
I am trying to calculate the net figure of leavers vs joiners over a time. My primary (active) date relationship is built on the start date my secondary (inactive) date relationship is built on ...
mattbrice
Solution Sage
Solution SageDoes your 'Date' calendar table include all dates as far back as the earliest date in the 'Employees All Time'[Leaving Date] column?
vanessafvgCommunity Champion
Community Championmattbrice hi yes it does have all the dates, Anonymous can't share the data but i know what the issue is, its counting the blanks. However I dont want it to count the blanks, how do i ignore them? I tried not(isblank) but that seems to have no affect, however if you recreate the measure where isblank is true then you can tae that new measure and minus the blanks from the original measure, but it seems like a very unelegant way to do it.