The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi All
Solved! Go to Solution.
Hi @admin11 ,
You could change YEAR(TODAY()) to the value of the slicer,Here can use MAX() ,as follows:
_Month last =
FORMAT (
DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ),
"mmm-yyyy")
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @admin11 ,
You could change YEAR(TODAY()) to the value of the slicer,Here can use MAX() ,as follows:
_Month last =
FORMAT (
DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ),
"mmm-yyyy")
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@admin11
Try
Month Last =
FORMAT(
DATE(
YEAR( SELECTEDVALUE(DATE[YEAR])),
MONTH(TODAY())-1,
DAY(TODAY()))
,
"mmm-yyyy"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group