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,

 

Thanks for the reply, but the calculation is still giving me the same as the closing balance. Any idea where could go wrong? 

 

I have a date table (marked as date table), the relationship between date and fact tables are through [Date] column on each table. 

 

I would like to show the closing/opening balance on a week-by-week basis. 

 

Thank you very much!