Adding data to non existing dates

[Anonymous]

Hello guys , i would request once again your help , i have to add data from the right side to the left side ( all in PowerBi but i thought it`s maybe better to let you know the excel) so i have this A829 but how you can see, in the data base he isn`t showing every day , but i need somehow to add the PROD even if he is not there because it affects my % when i do PCS/PROD because the datas from 1st 4th etc and they are not summing for % per Month but for % pe day it`s ok because it`s 0% how he should be . Can i get somehow help with , please.

In the excel is the real value (135600) but in the excel because of the missing dates he s just 79783 .

[v-angzheng-msft]

Hi, @Anonymous 

Not very clear for me, how does the view go from left to right? What is your expected result?

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello, how can i create the measure +0 ? 

Measure2 = SUMX(SUMMARIZE(Sheet1,'Table'[Date].[Date],Sheet1[PROD]),[PROD]) - this is the current measure that i use in this moment to sum PROD per Month

[amitchandak]

@Anonymous , You can do it like

SUMX(SUMMARIZE(Sheet1,'Table'[Date],Sheet1[PROD]),[PROD]) +0

But you have use dates table to get missing date

[Anonymous]

Still not working at all it`s not summing even with this formula, but thanks for trying to 😄 

[amitchandak]

@Anonymous , Create a date table and join it with the date of your table and create measure with +0

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.