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

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 ?