eomonth
3 Topics
Week per month that starts over every 4 weeks
I want to count each sales week of the month from 1 to 4, so that I can apply a color to the week ( 1 = red, 2 = blue, etc.). Here's what I tried so far, which works up until the end of February. I want to restartt the count from 1 to 4 for the week numbers as shown in the table below. Thanks for your time. "Week Ending", [Date] - WEEKDAY( [Date], 1) + 7, // Use the last week number of month to reset the counting, min week number = 1, max week number = 4 "Week in Month", IF( WEEKNUM( [Date]) > 4, WEEKNUM( [Date] ) - 4, WEEKNUM( [Date])) Date Week in Month Desired Week in Month 2/18/2024 4 4 2/19/2024 4 4 2/20/2024 4 4 2/21/2024 4 4 2/22/2024 4 4 2/23/2024 4 4 2/24/2024 4 4 2/25/2024 5 1 2/26/2024 5 1 2/27/2024 5 1 2/28/2024 5 1 2/29/2024 5 1 3/1/2024 5 1 3/2/2024 5 1 3/3/2024 6 2 3/4/2024 6 2 3/5/2024 6 2 3/6/2024 6 2 3/7/2024 6 2 3/8/2024 6 2 3/9/2024 6 2Solved1.2KViews0likes3Comments
Visualization Title - Show Previous Month in mmm format
Hi - I created the following measure to dislay on the title of my visualization: Title-Visualization01 = "01/2023 to "& &"/2023 Actual Spend vs. Target Spend" Result: 01/2023 to 10/2023 Actual Spend vs. Target Spend I would like the measure to display the following: Jan 2023 to Oct 2023 Actual Spend vs. Target Spend How do I convert MONTH(EOMONTH(TODAY(),-1)) to display the Month (Oct) instead of 10 ? Thanks - JerrySolved329Views0likes1Comment
First date of last month in a logical comparison
I am using this expression in filter part of calculate function: D_Employee[RowActiveFrom] < FIRSTDATE(PREVIOUSMONTH('Calendar'[date])) However Power BI doesn't calculate it and gives this error: "A function 'FIRSTDATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed." I'm just trying to compare the first date with another date and don't understand what is wrong here. Is there something to be corrected or a workaround to be used?Solved583Views0likes1Comment