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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Jeev
Frequent Visitor

How to Create a measure

Pic.pngHi All, How to create a measure for the below columns, I have create measuer ein Power Pivot just using SUM(ColumnRuns). But cant create a measure in Power Bi. I have multiple Run columns in my data where i have to add Run 1 +Run 2 in comparsion to date. How do we sum the below Run date compared to date in disregarding UP & DN Date  Segment Runs 1/02/2020 0:00 UP 127 1/02/2020 0:00 DN 124 2/02/2020 0:00 UP 121 2/02/2020 0:00 DN 120

 

DateSegmentRuns
01/02/2020Up

100

01/02/2020DN120
02/02/2020Up200
02/02/2020Dn150
2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi , @Jeev 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Sample data and expected output would help tremendously.

Best Regards,
Community Support Team _ Eason

amitchandak
Super User
Super User

@Jeev ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Like how we got 100 for 01/02/2020 Up


Appreciate your Kudos.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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