Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need to find the % based on Cumulative total Column

Hi Guys, I have table as below, I need to calculate Cumulative Total for each Type for Columns "FNet" and "FLevel" but as a calulcative Columns and not as measure. Since i need to add these columns ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Assuming WMAP is your table. It should be like. Are we taking of 1 table or 2 tables

Column in WMAP = sumx(filter(WMAP,WMAP[Date]<=earlier(WMAP[Date])),WMAP[FNet])
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak Only 1 Table Called wmap.., Below formula is not workly properly ( I mean the result is incorrect) where as the measure formula which you provided is working perfectly. But the Need is to create a Column and not measure.

 

 

 

Column in WMAP = sumx(filter(WMAP,WMAP[Date]<=earlier(WMAP[Date])),WMAP[FNet])

 

 

 
  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    If possible please share a sample pbix file after removing sensitive information.Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak Sorry for silly question,  iam unable to upload pbix file. I dont have any options to attach file. May i know how to do it./?

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        drop box, one drive, share link