Forum Discussion
RachelS
5 years agoFrequent Visitor
Help on Creating a percentage measure from a current value against a previous value
Hi everyone, I've been trying for a while to create to create a percentage measure to use on a correlated matrix, but the percentage is just coming out wrong. I've trying creating a table storing po...
- 5 years ago
ID Count = DISTINCTCOUNT( Movements[ID] ) % Moved = IF( ISINSCOPE( Movements[CurrentDateText] ), var CurrentPeriod = SELECTEDVALUE( Movements[CurrentDateText] ) var PreviousPeriod = TOPN(1, FILTER( ALLSELECTED( Movements[CurrentDateText] ), Movements[CurrentDateText] < CurrentPeriod ), Movements[CurrentDateText], DESC ) var CountPreviously = CALCULATE( [ID Count], PreviousPeriod ) var CountNow = [ID Count] return DIVIDE( CountNow, CountPreviously ) )I called the table Movements, obviously...
RachelS
5 years agoFrequent Visitor
Thank you very much! It worked wonderfully!
I really appreciate all your time and help on this matter