Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power Bi 🙂
Could you please assist me in writing a DAX function that represents the number of tickets that were carried over from previous months? For example, if I choose the month from a date slicer to be March, I need this measure to count the number of tickets created before 1st February 2022. So, I need the 1st day of the previous month to the month I select, not the month of today’s date.
I set it up as per below, but every time I need to manually modify the date in purple below in the CarriedOverColumn. I need it to work automatically. Thanks in advance!
Solved! Go to Solution.
you can get the first day of last month with EOMONTH( TODAY(), -2) + 1
you can get the first day of last month with EOMONTH( TODAY(), -2) + 1
Thank you johnt75. I tried this function however it reads data based on "today". I need it to subtract the month from the month I choose in the date slicer. So if I'm running the report of March, it should give me anything before Feberuary.
When I did this using the function "today", it shows anything before March not February.
Replace TODAY() with MAX('Date'[Date])