running total - Continious

[mruhullah]

Need help. I am trying to get running total for current quarter, previous quarter and previous year. My data may not have continuous daily numbers for all quarters. Some day might be missing. Below is the query which I am using. But I am getting a huge down due to non-availability of certain day in raw data. Is there any way I can get the continuous graph?

PYP&STotal=

VAR myvalue = [DayOfPQ]

var Quarter = [PQ_Name]

Prod = IF(VALUES(Revenue_Table[DayofQtr])<>[DayOfPQ],BLANK(), CALCULATE([P&SRev_PQ],FILTER(ALLSELECTED(Revenue_Table),Revenue_Table[DayofQtr]<=myvalue && Revenue_Table[Fiscal Quarter]=Quarter && Revenue_Table[Reportring_Group]="Services" )))

Ser = IF(VALUES(Revenue_Table[DayofQtr])<>[DayOfpQ],BLANK(), CALCULATE([P&SRev_PQ],FILTER(ALLSELECTED(Revenue_Table),Revenue_Table[DayofQtr]<=myvalue && Revenue_Table[Fiscal Quarter]=Quarter && Revenue_Table[Reportring_Group]="Product" )))

Return 

Prod+ser

Below is the graph which I am getting as I don’t have any entry for day 10 of previous year.

[v-danhe-msft]

Hi @mruhullah,

Could you have tried to switch the 'Type' in X-Axis to 'Continous'?

If it still not work, could you please offer your sample data to have a test if possible?

Regards,

Daniel He

[mruhullah]

@v-danhe-msft 

It is on continious. 

Not getting option to upload data 😞

[mruhullah]

@v-danhe-msft

please follow link to see the data

https://drive.google.com/file/d/1YGbfLbCzDk_czTbVQ4Mq7AaYusPmN75y/view?usp=sharing

[mruhullah]

Can anyone help on this??

[mruhullah · Accepted solution]

Figured out the solution.

Used date table and make 1 to Many relation. took date from date table insted of master table 🙂

[mruhullah]