Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Inception to Date financials

Hi,   I have certain measures stored in the database table that are all inception to date financials at the quarter end. To represent these financials properly, I need to pick the amounts from the ...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

I agree.  Keep seperate columns for each KPI.  We then write measures for each KPI depending upon the aggregation which we want to perform for each KPI - whether 'As at' or 'Sum'.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you Ashish_Mathur.!!