This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let | |
Quelle = Table.AddColumn(Trans, "Merge", | |
(case_insensitive) => Table.SelectRows(Dept, | |
each Text.Upper([Name]) = Text.Upper(case_insensitive[Name]))), | |
#"Expanded Merge" = Table.ExpandTableColumn(Quelle, "Merge", {"Name", "Dept"}, {"Emp.Name", "Emp.Dept"}) | |
in | |
#"Expanded Merge" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sales Profit = If ( | |
[RLS_Measure]=0; | |
BLANK(); | |
SUM(FactResellerSales[SalesProfit]) * [RLS_Measure] | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Profit pct = If ( | |
[RLS_Measure]=0; | |
BLANK(); | |
DIVIDE([Sales Profit]*100;[Sales Amount]) | |
* [RLS_Measure] | |
) | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Product Cost = if( | |
[RLS_Measure]=0 ; | |
BLANK(); | |
sum(FactResellerSales[TotalProductCost]) * [RLS_Measure] | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RLS_Measure = LOOKUPVALUE( | |
RLS[ShowMeasures]; | |
RLS[User];USERNAME() | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if( | |
maxx( | |
Filter(RLS, | |
RLS[User]=USERNAME() | |
) | |
,[Role]) = "Board" || | |
maxx( | |
Filter(RLS, | |
RLS[User]=USERNAME() | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if( | |
maxx( | |
Filter(RLS, | |
RLS[User]=USERNAME() | |
) | |
,[Role]) = "Board" || | |
maxx( | |
Filter(RLS, | |
RLS[User]=USERNAME() | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Umsatz = CALCULATE( | |
SUM(Umsatzliste[Wert]) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Umsatz Plan = | |
CALCULATE( | |
sum(Umsatzliste[Wert]); | |
Filter(Umsatzliste;Umsatzliste[Szenario]="Plan"); | |
Filter(Kalender;Kalender[relatives Jahr]>0) | |
) | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Umsatz Plan aktuelles Jahr = | |
CALCULATE( | |
sum(Umsatzliste[Wert]); | |
Kalender[relatives Jahr]=0 | |
) |