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.
We need to generate a calender containing the dates for last 30 days in DAX. I cant seem to find a good solution for this. How do I pass correct parameters to the CALENDAR method?
Solved! Go to Solution.
HI @Abhaykumar
Please try the following code to create a calculated table.
Date Table = CALENDAR( TODAY()-30, TODAY() )
HI @Abhaykumar
Please try the following code to create a calculated table.
Date Table = CALENDAR( TODAY()-30, TODAY() )
can we do it for maximum date availabe in data instade of today
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |