Forum Discussion

Raj12's avatar
Raj12
Helper III
4 years ago
Solved

Implementing Excel table in Power Bi where a column value depends on another column earlier value

I want to implement an excel table in Power Bi Ideally I have 1st column data i.e. for year 30th and rest all should populate based on calculation:   Year 30 31 32 33 34 35 36 37 38 3...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Raj12's avatar
Raj12
Helper III
4 years ago

Okay and how can we get sum of a measure in there like if I take Fund value in a card visual then it shows only the last value not the sum of all the rows for fund value  as shown below

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Write this measure

Measure = if(HASONEVALUE('Calendar'[Year]),[Fund value],SUMX(VALUES('Calendar'[Year]),[Fund value]))