Forum Discussion
YOY Total with IF Condition on customer value
Hi All, I need to show the Total Value for each YEAR based on IF condition applied on the customer. Example for 1 customer in current year: If (Total Sales = 0 , Last Year Sales, Total Sal...
Anonymous , Please find the file. I have corrected tmp_value. Refer Page 4
I created a new table for customer
amitchandak I have uploaded a sample PBIX file. Can you please take a look .
https://drive.google.com/drive/folders/1E_k7VbgImoTft43JOncSMrwrWtCwVUVx?usp=sharing
The correct Estimate_Value measure should be total of tmp_value measure per year. (Total at year level is not correct).
FY Year starts from 01st Sept. Below is the desired result .
2018 - 18558377
2019 - 22658571
2020 - 25084241
2021 - 29162252
What am I missing here ? Thanks a lot for your support.
amitchandak
Super User
Super UserAnonymous , Please find the file. I have corrected tmp_value. Refer Page 4
I created a new table for customer