The grand total is showing Blank while using Dates in period funciton. For example:
Calculate(sum(fact),datesinperiod(DateTime[DateKey],DATE(2007,08,24),-21,day)) gives me blank as a total. How can i fix to show grand total?
Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.
hi can you check out this link, it may help you .