FORMAT FUNCTION RETURN WRONG MONTH
FORMAT FUNCTION RETURN WRONG MONTH When i am using this format function result showing "January" which is incorrect because today is 23-Nov-2024, please help anyone has solution, currnetmonth = FORMAT(MONTH(TODAY()),"mmm") currnetmonth = FORMAT(MONTH(TODAY()),"mmmm")
How to get values of yesterday with DAX Measure
Hello everyone, I want to get values of yesterday from the table below: Date Com Amount 1/14 A 100 1/15 A 200 1/14 B 0 1/15 B 200 1/14 C 200 1/15 C 300 1/14 D 250 1/15 D 0 If today was 1/15 the values would be like below: A: 100 B: 0 C: 200 D:250 To do that, I tried Measure and Caluculated Column below: Column = TODAY() Measure = CALCULATE(SUM('Sheet1'[Amount]), dateadd('Sheet1'[Column], -1, Day)) But nothing appeared on Table visual. And also tried the below. but the output was the same as the original table data: Column = TODAY() -1 Measure = CALCULATE(SUM('Sheet1'[Amount]), dateadd('Sheet1'[Column], 0, Day)) Any advice please? Thanks, Vladi
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
Trouble with date comparison
I am trying to write a measure that will calculate the number of business days in a given period of time. I have a date table that starts at 1/1/2019 and ends on 12/31/2020. Here is my measure: Count of Business Days = var StartDate = MIN('Date'[Date]) var EndDate = IF(MAX('Date'[Date])>TODAY()-1, TODAY()-1, MAX('Date'[Date]) RETURN StartDate will return: 1/1/2019 EndDate returns: 44117 (sets data type to Decimal). If I change the data type to Date, I get: dddd MMMM d yyyy Why is it not returning the value of TODAY()-1? If I set the variable to only return TODAY()-1, it returns yesterdays date correctly
