Forum Discussion

andrejaar's avatar
andrejaar
Frequent Visitor
8 years ago

Time Intelligence Quarters - Purchases

Hi, My Goal is to know:    - Quantiy bought in current quarter ( CALCULATE(Sum(fDados[Quantity]);DATESQTD(dCalendar[Date]))    )    - Average Price Current Quarter ( CALCULATE(AVERAGE(fDados[Unit ...
Need Help
andrejaar's avatar
andrejaar
Frequent Visitor
8 years ago

Is there any Extra data that i should provide for helping get a solution?

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi andrejaar,

     

    Firstly, please check if subtotals are set to “on” like below:

     

    If still can’t see total value, for further test, could you please provide sample data with ‘dCalendar’ table?

     

    Regards,

    Jimmy Tao