Hello All , Kindly i need to have yesterday date for last year based on slected month from Dim_Date slicerSo as an example
if i chosed May 2023 yesterday will be 2022-06-05
if i chosed April 2023 yesterday will be 2022-04-05
Go to Solution.
Hi @AhmedHassan Please try
Yesterday Date =
VAR SelectedDate =
MAX ( Dim_Date[Date] )
VAR TodayDate =
DATE ( YEAR ( SelectedDate ) - 1, MONTH ( SelectedDate ), DAY ( TodayDate ) - 1 )
View solution in original post
Hello @tamerj1 you saved my day , cannot thank you enough. many thanks and much appreciated
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.