Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I am trying to run this formula,
in two different scenarios
1. Only up to today's date
2. Only up to a month before
Thanks
Solved! Go to Solution.
Hi @netanel
I managed to get something working (with my own dataset) with this:
new measure =
var currmonth= DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
return calculate(sum(invoice[INVOICE QUANTITY]),invoice[DEALER] in {"A"}, invoice[DATE]<= currmonth)
OEP_Actual HC =
var currmonth= DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
Return CALCULATE([Sum Amount N],
'EpmScenario'[ScenarioLvl3] IN { "OEP_Actual" },
'EpmVersion'[VersionLvl99Desc] IN { "Final" },
Dim_Time[Date]<=currmonth
)
HTH
Pi
Hi @netanel
I managed to get something working (with my own dataset) with this:
new measure =
var currmonth= DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
return calculate(sum(invoice[INVOICE QUANTITY]),invoice[DEALER] in {"A"}, invoice[DATE]<= currmonth)
OEP_Actual HC =
var currmonth= DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
Return CALCULATE([Sum Amount N],
'EpmScenario'[ScenarioLvl3] IN { "OEP_Actual" },
'EpmVersion'[VersionLvl99Desc] IN { "Final" },
Dim_Time[Date]<=currmonth
)
HTH
Pi
@netanel - try this DAX solution.
Please don't hesitate to give kudos to useful posts and mark solution as accepted if this works for you.
If you are unable to crack this Pls message.
Many Thanks
Connect me on LinkedIn
i try to run similar Measure but iam run in to problem
@netanel try removing the extra parenthesis as mentioned by @v-yinliw-msft if it doesn't work, send me the sample datasets to check. Pls note my datasets is a simple one as shown below.
Hi @netanel ,
Your formula has an extra parenthesis at the end, you can remove the parentheses from the last line to see if there is an error.
Hope these help you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |