Forum Discussion

sandy8910's avatar
sandy8910
Frequent Visitor
5 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Ensure that the last date in the Dimdate table goes only uptil today's date.

sandy8910's avatar
sandy8910
Frequent Visitor
5 years ago

Thanks Ashish however that I dont want to do as other visuals are using future dates as well

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Share the link from where i can download your PBI file and show the expected result.