Forum Discussion
Sameperiod LASTYEAR MTD
Hi Everyone, Here is the issue: Need to compare the revenue of 1st Jul'21 - 8th Jul'21 with the revenue of 1st Jul'20 - 8th Jul'20. When I use: Calculate([total revenue],SAMPEPERIODLASTYE...
Thansk Selva for help.
When I apply filter on dim table it gives nothing. No error. No value. can you please specifiy if you are refering to apply the filter on the data table where I am pulling the revenue from?
@sandy8910 yes, you should add filter on the table where you are pulling the revenue from