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

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

  • 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")