Forum Discussion

wdrain's avatar
wdrain
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 ...
Need Help
Anonymous's avatar
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's avatar
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's avatar
    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's avatar
      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.

      • wdrain's avatar
        wdrain
        Helper I
        7 years ago

        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 ?