Help with a DAX caculate column

[wdrain]

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

0073.0000.3683.0086" as shown below. 

I need like to replace this value with a DAX formula of the value of Lastest Package Version from the Package Software table.

Any Assistance would be greatly appreciated 

Thanks

The InstalledSoftware and PackagedSoftware are related and I have it correctly displayed in column 4. 

[Anonymous]

If you can sort the the specific column and use the DAX formula LASTNONBLANKS(<Table>,1) it should work.  All the best.

Regards

[wdrain]

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 ?

[wdrain]

The Latest Pkg_Version =

CALCULATE(

VALUES( InstalledSoftware[Version_Normalized]),

FILTER(ALL( InstalledSoftware[Version]), InstalledSoftware[Version] = LASTNONBLANK('Packaged Software'[Latest Packaged Version],1)

))

did return the last normalized Version but when this formula is plugged into my IF then statement for the Upgrade status all the values return true.

Upgraded Status =

IF (InstalledSoftware[Version_Normalized] >= CALCULATE(

VALUES( InstalledSoftware[Version_Normalized]),

FILTER(ALL( InstalledSoftware[Version]), InstalledSoftware[Version] = LASTNONBLANK('Packaged Software'[Latest Packaged Version],1)

)) ,

//"0073.0000.3683.0086",

"Upgraded", "Not Upgraded")

[Anonymous]

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.

[wdrain]

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...

MaxVersion = CALCULATE(

VALUES( InstalledSoftware[Version_Normalized]),

FILTER(ALL( InstalledSoftware[Version]), InstalledSoftware[Version] = LASTNONBLANK('Packaged Software'[Latest Packaged Version],1)

))

However when this value is referenced  in the Upgrade Status calculated formula I can the error messsage

"A circular dependency was detected:"  as shown below. Would you know how I can get past this error message ?

[Anonymous]

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.