Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rhborders
Helper I
Helper I

No accepting "=" in Switch function or IF function

I used this function = SWITCH(TRUE(),SUMX(Fact_Invoice_Line_Date_ID,Fact_Invoice_Line_Date_ID[Invoice_Date_Julian])>SUMX(Fact_Invoice_Line_Stdev,Fact_Invoice_Line_Stdev[Invoice Min Stdev]),1) which worked fine, however whenever I replace the ">" with an "=" I am unable to run the function. 

 

If you have any idea why this may be please let me know.

 

Thanks!

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@rhborders,

 

The latest version of Power BI Desktop seems to work fine.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Any time that I run this function my memory is maxed out and it can't display it. When I check my task manager it shows that all of my memory is being used from SASS. I have the data imported from SQL. Any idea why this may be?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.