Forum Discussion

andybamber's avatar
andybamber
Icon for Helper III rankHelper III
6 years ago

Help with PREVIOUSMONTH

Hello! I'm hoping someone could help me with a query regarding the PREVIOUSMONTH function.   I have a fact table containing a column of sales figures, the same table also contains a period key... i...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago
Time intelligence functions require all the dates without any gap so I don't think there is any option here for you other than create a date table with date granularity.