missing data

2 Topics

Divide all Returned sales values on only sales values in January from the same year
Hi all I asked this question ywo days ago , but seems I missinterpert my problem , https://community.powerbi.com/t5/Desktop/Divide-all-dates-values-on-a-a-specific-date-value-from-a/m-p/2191860#M802754 I will try to give more details her I have the the following table: And I would like to great new measure (column) that can fill all months sales with the value of January and then divide this is the returned column , meaning that I ma interesting in knowing the return ratio for each month comparing with only September . The resulted table should be like this : Where E2 = D2/C2 Thanks in advance Regards
Anonymous
4 years ago Place DAX Commands and Tips
794Views
0likes
2Comments
Year-to-Year formula
Hello everybody, I have a slight problem for my Year-to-Year formula. I want to calculate the evolution of sales from 2020 to 2021. It goes as follows: - Conso Net Sales = SUM('DATA (2)'[CONSO NET SALES1]) - ConsoNetSales PY (Previous Year) = CALCULATE([Conso Net Sales],CALCULATETABLE(FILTER('DATA (2)','DATA (2)'[CONSO NET SALES1]),DATEADD('Calendar'[Date], -1,YEAR))) - ConsoNetSales YOY (Year-to-Year) = VAR ValueCurrentPeriod = [Conso Net Sales] VAR ValuePreviousPeriod = [ConsoNetSales PY] VAR Result = IF(NOT ISBLANK(ValueCurrentPeriod) && NOT ISBLANK(ValuePreviousPeriod), ValueCurrentPeriod - ValuePreviousPeriod) RETURN Result So everything works. The only problem is that for some of my clients, I don't have data for 2020 and therefore, it does not want to show up in my Waterfall graph. I know also the solution: I just have to indicate PowerBI that if there is no Data for 2020 (Previous Year), it just has to substract the data of 2021 with 0. But I don't know how to add that in YOY formula... Can you please help me? Thank you very much
Solved
Anonymous
5 years ago Place DAX Commands and Tips
709Views
0likes
2Comments