Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Capitano_Fl99
New Member

Variance from categories

‎10-25-2023 04:43 AM

Hello,

 

i am struggling to find the good formula to calculate a variance. I have a table with categories which are quarters but in text format not in date type. And I have a measure in percentage in an other table. I don't arrived to calculate the variation between the categories .

 

What should I do use?

Message 1 of 3
485 Views
0
2 REPLIES 2
EylesIT
Resolver II
Resolver II

‎10-25-2023 05:38 AM

Try using a different calculation

Message 2 of 3
461 Views
0
Capitano_Fl99
New Member
In response to EylesIT

‎10-25-2023 06:03 AM

I tried various but no one works. 

Message 3 of 3
456 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All