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 People,
I have two columns in my dataset, one is [Date] and another is [Filing date].
I am looking for a dax formula which would return value based on following condition:
If [Filing date] < 11th day of Next month considering [Date] column then True else False.
For Example, if my date column is 18th April 2022 & my filing date coloumn is on or before 11th May 2022 then the result would be True and If filing date column is on or after 12th May then the result would be false.
Hope i have explained my query properly.
Thank you so much in advance.
Best Regards,
Shib
Solved! Go to Solution.
A new column
if([filling Date] < Eomonth([Date],0) +11, True(), False())
A new column
if([filling Date] < Eomonth([Date],0) +11, True(), False())
Thank you so much.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |