Forum Discussion
Solved
Calculate the closing estimate
Hi, I need to create a measure to divide the num days of a month/NUMBER OF DAYS WITH SALES DATA, ir order to calculate a closing estimate. Fe: November has 30 days and I know the sales for the f...
Tough to be specific here without sample data but perhaps something along the lines of:
Sales Data = CALCULATE(SUM(Sales[Sales]),FILTER(Sales,[Sales]<>BLANK()))
?
Thank you very much for your help. I have adapted the measurements and clues that you have given me and, after several attempts, it is already working