Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
There are formulas for the previous month (last month), last three months, next month... but is there a formula for the current month?
That is, I need to indicate the sales number of the current month and I can not find a way to do it.
Can you tell me the formula, please?
Thank you!
Solved! Go to Solution.
The DAX formula that has served me is this:
Hi @Syndicate_Admin ,
Please try below dax formula
Current date =
IF ( MONTH ( 'CALENDAR'[Date] ) = MONTH ( TODAY () ), "S", "N" )
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin,
Please find the below link for your reference.
https://community.powerbi.com/t5/Desktop/CURRENTMONTH/m-p/8673#M1493
If I resolve your problem Mark it as a solution and give kudos.
Thanks,
Hello!
None of the solutions proposed in the post you have passed me solves my problem.
For example, for the current date, I have this formula in the Calendar table.
The DAX formula that has served me is this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |