Forum Discussion

Gangasaniravi's avatar
Gangasaniravi
Helper I
2 years ago
Solved

Running Difference irrespective of dates using Direct Query

Hi,

 

i want to show running difference with out considering the dates because will get irregular dates . Please find below data.

Month-YearFTE
Jan-2176.25
Jul-2174.75
Oct-2174.25
Nov-2174.25
Jan-2278.25
Feb-2279.75
Aug-2279
Sep-2279.5
Oct-2279.5
Nov-2279

Output in a matrix visual:

Month-YearJan-21Jul-21Oct-21Nov-21Jan-22Feb-22Aug-22Sep-22Oct-22Nov-22
FTE76.2574.7574.2574.2578.2579.757979.579.579
Movement -1.5-0.5041.5-0.750.50-0.5
Need Help
Show and Tell