For some reason my highlighted custom column formula is not working. When the 4th column (Super Department ID) =80 then it should return the 470.4 in revenue but it's returning 0 instead. Could someone tell me what I'm missing here?
Many thanks in advance!
Jordan
1 ACCEPTED SOLUTION
@Anonymous Your Super Department column is text, so you either need to convert it to whole number or put double quotes around your 70 and 80 ( "70", "80")
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
@Anonymous Your Super Department column is text, so you either need to convert it to whole number or put double quotes around your 70 and 80 ( "70", "80")
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
