Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello everyone,
I want to retrieve a "HEADCOUNT" value on the first day of the current month, using DAX.
How should I approach this? I feel like the answer's right in front of me, but have not had luck so far.
Thanks.
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try something like below whether it suits your requirement.
Headcount measure: =
CALCULATE (
MAX ( 'TableName'[HEADCOUNT] ),
'TableName'[capturedate]
= EOMONTH ( TODAY (), -1 ) + 1
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Something like this?
Hi,
I am not sure how your datamodel looks like, but please try something like below whether it suits your requirement.
Headcount measure: =
CALCULATE (
MAX ( 'TableName'[HEADCOUNT] ),
'TableName'[capturedate]
= EOMONTH ( TODAY (), -1 ) + 1
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you, it worked!
Is there also a way to extract the same value from the first day, but of the previous month (instead of the current)?
Hi,
Thank you for your feedback.
Please try writing a measure like below.
The link down below, that describes about EOMONTH DAX function, might help.
Headcount measure Prev.month: =
CALCULATE (
MAX ( 'TableName'[HEADCOUNT] ),
'TableName'[capturedate]
= EOMONTH ( TODAY (), -2 ) + 1
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
70 | |
43 | |
42 |
User | Count |
---|---|
49 | |
42 | |
29 | |
28 | |
27 |