Forum Discussion

owenkosnen's avatar
owenkosnen
Frequent Visitor
4 years ago

Measure cannot be filtered by Date Slicer

Hi,   I have a measure that was created via "New Quick Measure" to calculate the QoQ% Change based on a calculated column (just the total of column A + B + C). I'd like to plot these column and th...
Need Help
Show and Tell
Tips and Tricks
owenkosnen's avatar
owenkosnen
Frequent Visitor
4 years ago

Hi Theo, 

 

Thanks a lot for your quick response!
I tried your suggestion to create these measures but not sure why I get Infinity as the value for QoQ%. I have made sure to change it to Percentage as well.
 

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

owenkosnen  sorry, I had an extra bracket at the end of the QoQ%

 

 

 

QoQ% = ( [QTD] - [Last QTR] ) / [Last QTR]