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