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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
asimpleman9to5
Frequent Visitor

Filtering data before calculation

Hi all.

asimpleman9to5_0-1660531019481.png

From the screenshot shown above, I would like to filter the serial number first before proceeding to calculate the difference in the higest and lowest voltage within each serial number. Is there a possible way in achieving the above mentioned outcome? Relatively new to power BI so I am quite unsure with how to approach this problem. Any help would be greatly appreciated.

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I assume you want to create a calculated column.

Please check the below picture and the attached pbix file.

 

Picture1.png

 

Diff calculated column =
MAXX (
    FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
    Data[Voltage]
)
    - MINX (
        FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
        Data[Voltage]
    )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

I assume you want to create a calculated column.

Please check the below picture and the attached pbix file.

 

Picture1.png

 

Diff calculated column =
MAXX (
    FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
    Data[Voltage]
)
    - MINX (
        FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
        Data[Voltage]
    )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Thank you!

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors