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")
Receiving Cannot mix text with values error
Here is the error I get: Here is the formula (one of anyway) that I'm trying to get to work: % Commitment = IF( MAX(DPP[Reason])="Leave"||MAX(DPP[Reason])="Project"||MAX(DPP[Reason])="PTO"||MAX(DPP[Reason])="Mentee", "Excluded", IF( CALCULATE( DIVIDE( SUM('AC'[Produciton]), SUM('DPP'[Daily Amount]), BLANK() ), DPP[Date] )=BLANK(), "Needs Review", FORMAT( CALCULATE( DIVIDE( SUM('AC'[Produciton]), SUM('DPP'[Daily Amount]), BLANK() ), DPP[Date] ), "Percent" ) ) ) The goal is to have a column with text values for certain situations and numerical values formated as percentages for when there is a valid value to present. I've actually tried a few variations on this and an just burnt out. I know there has to be a way, I feel like I got this to work before, but wrapping the calculate in VALUE didn't help, and changing from "" to BLANK didn't help. Is it the IF statement as a whole? I close my eyes and just see dax formulas scrolling now. Please help. Let me know if any more information is needed.
