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.
Hi
I would be happy if you could help me. I have also used measure to solve that but failed.
Problem : If today is the first day of current month , for example ( 01 August 2023 ) then start the calendar from the beginning of previous month till the end of previous month --> 01 July 2023 .... till 31 July 2023.
Else start the calendar from beginning of current month ( 01 August 2023 ) till the end of current month ( 31 August 2023)
Thanks in advance.
Regards
Solved! Go to Solution.
Worked ! Thanks a lot.
The CALENDAR function returns a table, so I don't think that is what you are wanting. Is this what you are looking for?
Column =
VAR _Today = TODAY()
RETURN
IF (
DAY ( _Today ) = 1,
EOMONTH ( _Today, -2 ) + 1 & " - " & EOMONTH ( _Today, -1 ),
EOMONTH ( _Today, -1 ) + 1 & " - " & EOMONTH ( _Today, -0 )
)
It's not really clear to me what is the exact string you are wanting to see in that colmn today, Aug 12th and what would you want to see when TODAY() = Sept 1st?
What do you want to see on the rows for dates 3 months ago?
As an example.
If today is 01.08.2023 ( first day of current month)
I would like to have calendar table between 01.07.2023 - 31.07.2023
else ( today is <> 01.08.2023 )
I would like to have calendar table between 01.08.2023 - 31.08.2023
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 |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |