Forum Discussion

Helper I

7 years ago

Help with a DAX caculate column

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

Anonymous

Not applicable

7 years ago

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

Regards

wdrain
Helper I
7 years ago
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
  Helper I
  7 years ago
  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
    Not applicable
    7 years ago
    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.

Related content