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.
Web Version Shifting Visual Alignment
Hello, I am running into an issue when publishing my report to the web, specifically with the new card visual. In the desktop version, my reference label titles are directly centered over the value metric. However, when I publish to the web the reference label headers seem to shift left justified. Again, it looks perfectly centered in the desktop version. I tried digging around the card specs and couldn't find any sort of horizontal alignment setting. See Screenshot: Was there a new update recently that would cause this? This was not a issue when publishing this report a week ago
