Forum Discussion
Dynamic value updates
I am trying to find the easiest way to dynamically update my customer inventory with the latest software release for multiple products
i.e.
Product 1 is currently running software release "1X" but the newest Generally Available software is "1Y"
Product 2 is currently running software release "2X" but the newest Generally Available software is "2Y"
Product 3 is currently running software release "3X" but the newest Generally Available software is "3Y"
I have a custom column that checks if current software = latest GA software (but new software is delivered 3 monthly and i need an easy way to update)
Note: In real life there are 10 to 15 products and 100's of locations
Any advise or pointers would be appreciated
Regards
Gary Gray
3 Replies
- lbendlinSuper User
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - AnonymousNot applicable
Hi Anonymous ,
You can try replacing X with Y.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi Stephen,
Thank you for response, yes it will work but not as elegant as had hoped
Would be nice to have one table that parameters could be changed and this updates all reports, plus is available to put as a visual in a presentation slide 🙂
Gary