Forum Discussion
Need help with Dax/Measure.
Hello All,
Need help with Dax craetion, Any help would be appreciated.
below is case or condition we have, this is i need to pass as a line or secondary Y axis to the combo chart (bar + line combo)
I have tried multiple ways but some how the line is not passing through. tried using switch, or, and.
I have week column, which holds values like, week 0, week 1, week 2......
below is the problem statement :
- End of Month Target:
- Achievable: Min of (Total in-scope open orders for the given Market at Week 0 * 30% or Achievable> 120days at Week 0)
- IN PROCESS: Min of Total in-scope open orders for the given Market at Week 0 * 30% or IN PROCESS > 120days a Week 0
- Weekly Target
- Achievable:
- If Achievable> 120days at Week 0 < Total in-scope open orders for the given Market at Week 0 * 30%:
- Target is flat line at: Total in-scope open orders for the given Market at Week 0 * 30%
- If Achievable> 120days at Week 0 > Total in-scope open orders for the given Market at Week 0 * 30%:
- The Weekly target should be a linear line from *
- Week 1 target for *Achievable> 120days*:
- Achievable> 120days at Week 0 - 1 *(Achievable> 120days at Week 0 - Total in-scope open orders for the given Market at Week 0 * 30%/4)
- Week 2 target for *Achievable> 120days*:
- Achievable> 120days at Week 0 - 2 *(Achievable> 120days at Week 0 - Total in-scope open orders for the given Market at Week 0 * 30%/4)
1 Reply
- Greg_Deckler
Community Champion
JadhavVarsha_13 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.