Forum Discussion
Solved
Help recreating excel sample formula in Power Bi
Hello, As the tittle says, I'm having issues with the mentioned task. The column 'Otros' and 'Total Gen' are the ones I can't replicate. Any help would be amazing...
Hi supr4
Create calculated columns as:
f>12meses… = IF( 'Table 1'[Rango]="f>12meses…", 'Table 1'[Stocks/], BLANK() )d.6-9meses = IF( 'Table 1'[Rango]="d.6-9meses", 'Table 1'[Stocks/], BLANK() )Otros = 'Table 1'[Stocks/]-'Table 1'[f>12meses…]-'Table 1'[d.6-9meses]Total Gen = 'Table 1'[f>12meses…]+'Table 1'[Otros]Here is the output:
The demo is attached, please try it.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi supr4
Create calculated columns as:
f>12meses… =
IF(
'Table 1'[Rango]="f>12meses…",
'Table 1'[Stocks/],
BLANK()
)d.6-9meses =
IF(
'Table 1'[Rango]="d.6-9meses",
'Table 1'[Stocks/],
BLANK()
)Otros =
'Table 1'[Stocks/]-'Table 1'[f>12meses…]-'Table 1'[d.6-9meses]Total Gen =
'Table 1'[f>12meses…]+'Table 1'[Otros]
Here is the output:
The demo is attached, please try it.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!