Status:
Done
Urgent!! Dax Help Required For calculation
Hi Links Team PBCommunity PBICommunity Issue :- I have site, month/year, Sales and region head column in my Table. Now i have to find out those sites where the sales are going continous down ...
Hello Anonymous!
Here is my solution:
1. In Power Query, I changed the type of "site" to text, sorted ascending by site and then ascending by month/year; then I added an index column.
2. I updated measure TOtal_month_selected with an AllSelected statement:
3. I added a calculated column called Decrease, with the following code:
4. I created the final measure Continuous Descent that displays only the sites that had a continuous decrease in the selected months:
This solution gives the desired results:
Here is my pbix: https://drive.google.com/file/d/1uWeCCSI2lz-mr-C9dh80YSiVAgrnYanr/view?usp=sharing
Let me know how it goes!
Cheers!
Cristi