Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cumulative backlog

Dear all,   I have create this measure and it's doesn't work : Backlog = CALCULATE([Balance];FILTER(all('Date');'Date'[Date]<=MAX('Date'[Date])))   Result =      Ps : Balance measure = C...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks for your answer but I already resolve the issue. It was link to the data type of my date columns, I had just to change data types in Power BI Query ! 

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Please try to use the formula as below. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Backlog = SUMX(FILTER(all('Date');'Date'[Date]<=MAX('Date'[Date]));[Balance])