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.
Help I can't figure the correct dax formula to return the "Lastest Packaged Version" from the Packaged Software table in my Dax formula shown below. I have the Latest Packaged Version currently hard coded with
The InstalledSoftware and PackagedSoftware are related and I have it correctly displayed in column 4.
If you can sort the the specific column and use the DAX formula LASTNONBLANKS(<Table>,1) it should work. All the best.
Regards
LW,
Thanks for the quick reply, Unfortunely the LastNONBLANK function did'nt work. The Upgrade Status value returned True for all the values. Any other recommendations ?
You might need to do step by step approach rather adding everything in one formula.
1. try to filter out the latest first - create a column
i.e. MaxVersion = CALCULATE(FILTER(yourtablename[Name]=EARLIER(yourtablename[Name]))
2. Create a column called status
IF(installedSoftware[Version_Normalized] >= MaxVersion, "Upgraded", "Not Upgraded")
Thank you.
Hi LW thanks for the suggestion.
I think it got me closer but it still does not work!
I attempted get the Max version using the formula as you suggested but was not able to get it work ...
MaxVersion = CALCULATE(FILTER(yourtablename[Name]=EARLIER(yourtablename[Name]))
So I created a another formula that does provide the normalized version of the Latest package version, as shown below...
Hi @wdrain
I'm going to assume thats because it's not a number and therefore can't be compared with. It looks like it's text.
I've tried to import something similar to you and it comes in as text and Power BI is unable to convert it to any kind of number.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |