Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I need your help.
I have sales data as follows:
I need to create a dax measure to return a date.
Result should be the date when Running total >= Target (60)
Thanks in advance.
Solved! Go to Solution.
try to create a measure with the code below:
Hi @Anonymous ,
You can try this method:
New a measure:
Result = CALCULATE(SUM('Sales'[Target Date]), 'Sales'[Running Total] >= 60)
The result is:
And there is another mothed to solve your problem:
Hope this helps you.
Here is my PBIX file.
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.
try to create a measure with the code below:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
21 | |
20 | |
14 | |
13 |
User | Count |
---|---|
43 | |
37 | |
25 | |
24 | |
22 |