Forum Discussion
Dynamic Variance between Figures
I've used PARRALLELPERIOD for MONTH, to get FTE difference between the previous month. However I have to do another for YEAR, QUARTER etc. Is there any way at all to do with dynamically with ...
Greg_Deckler
Community Champion
Community Championpbijack93 Yeah, my advice is to not use DAX TI functions, they are not flexible or intuitive. Better to do it with just good old FILTER function.
@Greg_Deckler Thank you - ive been playing with variables and filters - but the result then gives me everything in two columns on the matrix.
Would you be able to provide me with an example that i can build off using my data please? Id be really grateful.
Thank you
Jack