Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello amazing Power BI community!
I hope someone can help me!
Some time ago I had this problem: https://community.powerbi.com/t5/Desktop/Current-Month-starting-from-the-16th/m-p/758664#M365643
So I know how to start the month from the 16th. Now I have another pproblem. The code i have used to show the current month (from the 16th of september to the 15th of october) looks like this:
CurrentMonth15 = Var First = FORMAT(IF(DimDate[DayofMonth]>=16;DATE(DimDate[år];DimDate[Monthof Year];16);IF(DimDate[DayofMonth]<=15;DATE(DimDate[år];DimDate[Monthof Year]-1;16)));"MM/YYYY") var second = FORMAT(NOW();"MM/YYYY") return IF(First = second;"yes";"No")
Now; My problem is, that when the 'real' month changed from the 30th of september to the 1st of october, the code shows the 'current month starting from the 16th' as the 16th of october to the 15th of november. I would like it to still show the 'current month' as the 16th of september to the 15th of october, until the 16th of october, where the month should then change to the 16th of october to the 15th of november.
So in short; I would like my month (16th of september to 15th of october) to still be the 'current month' even though we switch months from september to october. I hope it makes sense! 🙂
Antoher info: I have an entire dimdate table, I don't know if this will help with anything (dates, years, q's, ordinal date, day of week, weekending, etc.)
I am looking forward to hearing from you amzing PBI gurus! 😄
Hi @Ashish_Mathur and @v-shex-msft
Maybe this visual will give a better explanation:
We are currently in October, but as our timeregistration periode runs from the 16th of september to the 15th of october. Therefore I need the 'current month' to run from the 16th of september, even though we have enterd the 9th of october. On the 16th of october the 'current month' table should then change to show the dates from the 16th of october to the 1th of november.
Currently, when we change months from september to october, the 'current month' (starting from the 16th) also changes.
Sorry but i cannot understand. May be someone else will help you.
Hi,
I am not sure of what you want but my guess is that you want to get the month name in the Calendar Table. Your definition of a month is 16th of any month to 15th of next month i.e. July 16 to Aug 15 would be July. Try this calculated column formula in the Calendar Table
=FORMAT(Calendar[Date]-16,"mmmm")
Does this work?
HI @Anonymous ,
Hmmm, it sounds like a common fiscal date issues.
I'd like to suggest you to add a calculated field to stored modify date. (current date -15) After these steps, you can use the new fiscal date as date axis of your visuals, it will group your records based on real date 'current month' 16th to 'next month' 15th.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |