Is there a way to build previousmonth in a measure instead of a table you showed? Like this measure will always return the previous month? Don't want to hard code previous month by naming the month either. Want it to be dynamic, is this possible
how dax to make first month or year is zero (0) exp : when we start in jan24, feb24, mar24 so on the provious month in Jan is 0 (not diff from Dec 23). thank
Thank you! The best explanation!!!
Thanks for sharing! What is the formula for Headcount calculation you use, please?
Hey there, here it is: ua-cam.com/video/0u9yF7lKGW0/v-deo.html at around 5:00
Great video - do you know how is best to exclude working days from his? I'm current tracking changes daily and get a -100% when using this method
amazing like always!!
thank you
You're welcome Bandar, and thanks for watching!
Is there a way to build previousmonth in a measure instead of a table you showed? Like this measure will always return the previous month? Don't want to hard code previous month by naming the month either. Want it to be dynamic, is this possible
can you please make a video on retention? rolling 12 months, 90 day, 180 days, 365 days.
Sir thanks
Can you tell me difference between dateadd and previousyear
Well dateadd allows you to change the intervals like quarters, months, or days, whereas previousyear will only always give you previousyear
Thank you
Hi, great video as always. Any idea why previous quarter might provide a blank value? I have a working current quarter equation... I'm so confused
Did you ever find a solution? I'm having the same problem.
Perhaps you will have to add the year as a separate column to the calendar table.
Thank you,it worked 💃💃😂
how dax to make first month or year is zero (0) exp : when we start in jan24, feb24, mar24 so on the provious month in Jan is 0 (not diff from Dec 23). thank
What is the Headcount measure here without that we cant proceed
What's the difference between SAMEPERIODLASTYEAR and PREVIOUSYEAR Dax?
is calendar name of your table that has the date
Hi there, yes it is!
Please can u share mail id or number i have doubt