Loading ...

Adding column in inventory report | CLEARIFY

Posted in: QQube    Excel Power Pivot

Editing date column in inventory report

Subscribe to RSS
  • I am trying change the calculation for the sales date range in the inventory report. I see that I change it in the Power Pivot tab > Measures > Manage Measures. I am trying to change the Last Year's Sales Quantity to All, but when I go to edit the calculation I am not sure of how to change it to get all sales. Can anyone please tell me what the formula should be changed to?

  • Since you want all dates, then you don't need a calculation. By default it is already all dates, so you just need the Sales Qty column.

  • Answered

    Matt, are you looking for ALL Sales (irregardless of period), then Chuck's answer applies.. Or are you looking for a measure where you want the  grand Total Sales Qty for Last Year, irregardless of filter.  So you can do  a percent of total type of calc? if later, lots of ways to do... check out Matt ALingtons blog...https://exceleratorbi.com.au/the-all-function-in-dax/            Either way, I would write a new measure and not override what QQube has.  

                          

Page 1 of 1 (3 items)