The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everybody,
please I need your help again.
I have table which looks like:
What I need is a function which helps me to determine the change of promised delivery date based on "Doc No" and "Article".
In the end the solution could look like:
or like that:
I don´t know which solution is the best one for me, because I don´t how to exactly I am going use it in report.
I am thankfull for every help I can get.
If you need further information or I need to explain more, please say something...
THANK YOU!!!
freiburgc
Solved! Go to Solution.
@Anonymous add following measure, change column name and table name as per your data model.
Change of Promised Delivery Date = CALCULATE( COUNTROWS( 'Table' ), FILTER( ALLEXCEPT( 'Table', 'Table'[Article], 'Table'[Doc No] ), 'Table'[Promised Delivery Date] < MAX( 'Table'[Promised Delivery Date] ) ) )
And here is the output
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous add following measure, change column name and table name as per your data model.
Change of Promised Delivery Date = CALCULATE( COUNTROWS( 'Table' ), FILTER( ALLEXCEPT( 'Table', 'Table'[Article], 'Table'[Doc No] ), 'Table'[Promised Delivery Date] < MAX( 'Table'[Promised Delivery Date] ) ) )
And here is the output
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2kthank you very much for your help! It seems like it´s working!!! I am back at work next week, so I can really test it.
Thanks!!
freiburgC
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
110 | |
106 | |
75 | |
62 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |