Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Helper IV
10 years ago

Error in PowerBI Deskopt using LastDate function

Hi Friends, I am using lastdate function in my tabular model. Following is my measure SUMX(VALUES(ClaimRoot[Claim Number]),                                            CALCULATE(  SUM(ClaimRoot[Th...
Need Help
  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    vickyprudhvi Tell us more about the table you are working on. The formula by iteslf seems okay

    • austinsense's avatar
      austinsense
      Impactful Individual
      10 years ago

      Also it would help if you write out in a sentence what you want the measure to calculate. I's like DAX poetry, bonus point for a haiku ...

       

      every claim number,

      sum "three points day quantity",

      last day in filter

       

      I don't think you can throw a function like that into the second argument of a calculate.  you might need this ...

       

      SUMX(VALUES(ClaimRoot[Claim Number]),
     CALCULATE(  SUM(ClaimRoot[ThreePointDaysQuantity]),
          FILTER(ClaimRoot,
                     Cl​aimRoot[EffectiveTimestamp] = LASTDATE(Cl​aimRoot[EffectiveTimestamp]
      	  )
           )
      )