Not able to force date format in DAX formula
Hi, I struggle with using date inside a formula. I have tried many different options, none is working. Here is my current formula, somehow it seems like I cannot pull the month and date out from the "Max(date)" The only thing that works is when I hard code the date like this Date(2023, 10, 31), as you can see in my formula I try to add a variable, it does not work. However, this variable works if I write it in a Measure.... The table Calendar is an island, not connected to any other table. And I use a date-slicer for defining what date it is. I have tried to format all dates, both in the Query data loading, and in front view. I have tried using Month(Max(Date)) etc, I have tried Mid(Max(Date),4,2), or Left(Max(Date),2) etc.... I have tried to add new column in my table, new measure... What is the reason for this struggle with date and date format? Best regards E
How to make a graph understand that the week number is next year (to make the date sort right)?
Hi, I have this data: And I have made this graph - which shows completed sales and expected future sales. This works great for when I use the "Date" field, but I want it on week level, and when I do that it looks strange (see picture below), because Power BI doesn't understand that week 1 is next year, and hence is after week 52. Is there a way to make it understand that week 1 is next year? And hence that the graph looks more similar to the one with "Date"? Thanks in advance, highly appreciate it 🙂Converting Month Names in short text to Date
I have to identical tables with Column named month which has short text values of month names (Jan, Feb, Mar.....etc). I need to convert it to date. I am using below formula which works for one table but for other it throws an error. Can anyone please explain what I am doing wrong or any better alternatives. Formula: Month Seq = DATEVALUE(FORMAT( "1-" & FY20[Month] & "-" & FY20[Year], "dd-mmm-yy" )) Error:Filter month year column to exclude future dates from today
I have a dates key table that runs from Jan 2018 - Jan 2021. I have a month year column (Text Format): Month Year = FORMAT('DimDate'[DateS],"MMM YYYY") However it pulls in all dates in the dates key range: Is there a way to exclude future dates from: FORMAT('DimDate'[DateS],"MMM YYYY"),<=TODAY() Thanks in advance
