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
wvdmpowerbi
Regular Visitor

Calculate and merge between tables

Hi

 

See attached the following screenshot.

 

The information is from 2 tables:

 

Table 1 - Generation:

IntervalStart

IntervalValue

 

Table 2 - NIM:

NMI

UOM

RegisterIDCapture.PNG





 

I would like to put a formula in that says:

 

IF RegisterID = "E1", then make the corresponding IntervalValue date negative by multiplying by -1

 

I also would like to consolidate or SUM where data in NMI column is = "7102000057", "7102000058", & "7102000059",





Thanks

 

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @wvdmpowerbi ,

 


IF RegisterID = "E1", then make the corresponding IntervalValue date negative by multiplying by -1

 


To create a calculated column as below.

Column = IF('Table'[RegisterID]="E1",'Table'[IntervalValue]*-1)

Capture.PNG

 


I also would like to consolidate or SUM where data in NMI column is = "7102000057", "7102000058", & "7102000059",

 


For the request, what did you want? A measure of a calculated table?

Measure:

Measure = CALCULATE(SUM('Table'[Column]),FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059))

Table:

filter table = FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059)

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

BTW, Pbix as attached.

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

7 REPLIES 7
v-frfei-msft
Community Support
Community Support

Hi @wvdmpowerbi ,

 


IF RegisterID = "E1", then make the corresponding IntervalValue date negative by multiplying by -1

 


To create a calculated column as below.

Column = IF('Table'[RegisterID]="E1",'Table'[IntervalValue]*-1)

Capture.PNG

 


I also would like to consolidate or SUM where data in NMI column is = "7102000057", "7102000058", & "7102000059",

 


For the request, what did you want? A measure of a calculated table?

Measure:

Measure = CALCULATE(SUM('Table'[Column]),FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059))

Table:

filter table = FILTER('Table','Table'[NIMI]=7102000057 || 'Table'[NIMI]=7102000058 || 'Table'[NIMI]=7102000059)

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

BTW, Pbix as attached.

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Mariusz
Community Champion
Community Champion

Hi @wvdmpowerbi 

 

Can you provide a useable sample?


Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski



 

 

How do i attach a same file?

Hi @wvdmedify 

 

Please see the below.

image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

1.PNGI dont have that access, any other method?


@Mariusz wrote:

Hi @wvdmedify 

 

Please see the below.

image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 


 

Hi @wvdmedify 

 

You can copy from excel and paste in the body of the comment section.

 

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 



710200005730/06/2019 0:153kWhE1
710200005830/06/2019 0:154kWhE1
710200005930/06/2019 0:151.39kWhE1
710200005730/06/2019 0:304kWhE1
710200005830/06/2019 0:304kWhE1
710200005930/06/2019 0:301.39kWhE1
710200005730/06/2019 0:453kWhE1
710200005830/06/2019 0:455kWhE1
710200005930/06/2019 0:451.42kWhE1
710200005730/06/2019 1:003kWhE1
710200005830/06/2019 1:004kWhE1
710200005930/06/2019 1:001.41kWhE1
710200005730/06/2019 1:154kWhE1
710200005830/06/2019 1:154kWhE1
710200005930/06/2019 1:151.42kWhE1
710200005730/06/2019 1:303kWhE1
710200005830/06/2019 1:305kWhE1
710200005930/06/2019 1:301.44kWhE1
710200005730/06/2019 1:454kWhE1
710200005830/06/2019 1:454kWhE1
710200005930/06/2019 1:451.41kWhE1
710200005730/06/2019 2:003kWhE1
710200005830/06/2019 2:005kWhE1
710200005930/06/2019 2:001.41kWhE1
710200005730/06/2019 2:153kWhE1
710200005830/06/2019 2:154kWhE1
710200005930/06/2019 2:151.4kWhE1
710200005730/06/2019 2:304kWhE1
710200005830/06/2019 2:304kWhE1
710200005930/06/2019 2:301.4kWhE1
710200005730/06/2019 2:453kWhE1
710200005830/06/2019 2:455kWhE1
710200005930/06/2019 2:451.41kWhE1
710200005730/06/2019 3:004kWhE1
710200005830/06/2019 3:004kWhE1
710200005930/06/2019 3:001.46kWhE1
710200005730/06/2019 3:153kWhE1
710200005830/06/2019 3:155kWhE1
710200005930/06/2019 3:151.43kWhE1
710200005730/06/2019 3:304kWhE1
710200005830/06/2019 3:304kWhE1
710200005930/06/2019 3:301.39kWhE1
710200005730/06/2019 3:453kWhE1
710200005830/06/2019 3:455kWhE1
710200005930/06/2019 3:451.44kWhE1
710200005730/06/2019 4:004kWhE1
710200005830/06/2019 4:004kWhE1
710200005930/06/2019 4:001.39kWhE1
710200005730/06/2019 4:153kWhE1
710200005830/06/2019 4:155kWhE1
710200005930/06/2019 4:151.4kWhE1
710200005730/06/2019 4:304kWhE1
710200005830/06/2019 4:304kWhE1
710200005930/06/2019 4:301.43kWhE1
710200005730/06/2019 4:453kWhE1
710200005830/06/2019 4:454kWhE1
710200005930/06/2019 4:451.43kWhE1
710200005730/06/2019 5:004kWhE1
710200005830/06/2019 5:005kWhE1
710200005930/06/2019 5:001.53kWhE1
710200005730/06/2019 5:153kWhE1
710200005830/06/2019 5:154kWhE1
710200005930/06/2019 5:151.45kWhE1
710200005730/06/2019 5:303kWhE1
710200005830/06/2019 5:305kWhE1
710200005930/06/2019 5:301.41kWhE1
710200005730/06/2019 5:454kWhE1
710200005830/06/2019 5:454kWhE1
710200005930/06/2019 5:451.43kWhE1
710200005730/06/2019 6:003kWhE1
710200005830/06/2019 6:004kWhE1
710200005930/06/2019 6:001.41kWhE1
710200005730/06/2019 6:154kWhE1
710200005830/06/2019 6:155kWhE1
710200005930/06/2019 6:151.46kWhE1
710200005730/06/2019 6:303kWhE1
710200005830/06/2019 6:304kWhE1
710200005930/06/2019 6:301.44kWhE1
710200005730/06/2019 6:454kWhE1
710200005830/06/2019 6:455kWhE1
710200005930/06/2019 6:451.91kWhE1
710200005730/06/2019 7:003kWhE1
710200005830/06/2019 7:004kWhE1
710200005930/06/2019 7:001.47kWhE1
710200005730/06/2019 7:155kWhE1
710200005830/06/2019 7:156kWhE1
710200005930/06/2019 7:151.42kWhE1
710200005730/06/2019 7:3025kWhB1
710200005830/06/2019 7:3031kWhB1
710200005930/06/2019 7:301.42kWhE1
710200005730/06/2019 7:45114kWhB1
710200005830/06/2019 7:45137kWhB1
710200005930/06/2019 7:451.38kWhE1
710200005730/06/2019 8:00419kWhB1
710200005830/06/2019 8:00505kWhB1
710200005930/06/2019 8:001.41kWhE1
710200005730/06/2019 8:151029kWhB1
710200005830/06/2019 8:151235kWhB1
710200005930/06/2019 8:151.39kWhE1
710200005730/06/2019 8:301737kWhB1
710200005830/06/2019 8:302085kWhB1
710200005930/06/2019 8:301.43kWhE1
710200005730/06/2019 8:452472kWhB1
710200005830/06/2019 8:452968kWhB1
710200005930/06/2019 8:451.41kWhE1

Thanks Maruisz

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.

Top Solution Authors
Top Kudoed Authors