Forum Discussion

pudaludalu's avatar
pudaludalu
Frequent Visitor
6 years ago

Slicer not working in table

Hi,   I've got a table like below. I managed to get [Closing Balance], [Opening Balance] and [Running Balance] working, as is shown in the table.        However, when I add a slicer (For ex...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The opening should be cumulative till last month-end date ??

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,endofmonth(dateadd(date[date]),-1,month))))

Or last date total

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] =maxx(date,endofmonth(dateadd(date[date]),-1,month))))

use all(date), if needed

pudaludalu's avatar
pudaludalu
Frequent Visitor
6 years ago

Hi,

 

Can you please help me on this? I'm so desparate to get it working... 

 

At the moment, the [Closing Balance] and [Opening Balance] are returning the same value even though I used DATEADD for previoius month. Is there anything else I need to pay attention to get this to work?

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi pudaludalu 

     

    you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.