Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
@Anonymous,
Please check if the following DAX returns your expected result. If not, please share sample data of your column and post desired result here.
PYDate = DATE(YEAR(Table[date])-1,MONTH(Table[date]),DAY(Table[date]))
Regards,
@Anonymous,
Please check if the following DAX returns your expected result. If not, please share sample data of your column and post desired result here.
PYDate = DATE(YEAR(Table[date])-1,MONTH(Table[date]),DAY(Table[date]))
Regards,
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |