Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
No mês de outubro | |||
Mês | Reclamações | Projeção | Regra |
pôr | 576 | 576 | Mês fechado |
para um | 730 | (576/0,30)*0,38 | |
Novembro | 384 | (576/0,30)*0,20 | |
dez | 173 | (576/0,30)*0,09 | |
No mês de Novembro | |||
Mês | Reclamações | Projeção | Regra |
pôr | 576 | 576 | Mês fechado |
para um | 589 | 589 | Mês fechado |
Novembro | 288 | (576+589/0,68)*0,20 | |
dez | 130 | (576+589/0,68)*0,09 | |
No mês de Dezembro | |||
Mês | Reclamações | Projeção | Regra |
pôr | 576 | 576 | Mês fechado |
para um | 589 | 589 | Mês fechado |
Novembro | 350 | 350 | Mês fechado |
dez | 141 | (576+589+350/0,88)*0,09 |
Desde já agradeço a ajuda
Solved! Go to Solution.
where are these rules defined? 0.3, 0.38, 0.2, 0.09 ? Is that something that is fix or do you expect to be able to model these?
Your numbers for November and December are off by a bit.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dcyxDYAwDETRXVxHyL7IEM8SZf81iBIsGWGKu+IXr3cSpkI2p9c5n49Kozx53Y4tVPGKEOGRbVfJXXFXm71oyWhJaeQ0/mg4XZWjjo8+bg==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t, #"Projected Month" = _t, Actual = _t, Weight = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", Int64.Type}, {"Projected Month", Int64.Type}, {"Actual", Currency.Type}, {"Weight", type number}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Projection", (k)=> k[Actual] ?? (let f=Table.SelectRows(#"Changed Type",each [Month]=k[Month] and [Projected Month] < k[Projected Month] and [Actual]<>null) in List.Sum(f[Actual])/List.Sum(f[Weight])*k[Weight]),Currency.Type)
in
#"Added Custom"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.
Estes valores são alterados anualmente, eles estão em uma tabela
where are these rules defined? 0.3, 0.38, 0.2, 0.09 ? Is that something that is fix or do you expect to be able to model these?
Your numbers for November and December are off by a bit.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dcyxDYAwDETRXVxHyL7IEM8SZf81iBIsGWGKu+IXr3cSpkI2p9c5n49Kozx53Y4tVPGKEOGRbVfJXXFXm71oyWhJaeQ0/mg4XZWjjo8+bg==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t, #"Projected Month" = _t, Actual = _t, Weight = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", Int64.Type}, {"Projected Month", Int64.Type}, {"Actual", Currency.Type}, {"Weight", type number}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Projection", (k)=> k[Actual] ?? (let f=Table.SelectRows(#"Changed Type",each [Month]=k[Month] and [Projected Month] < k[Projected Month] and [Actual]<>null) in List.Sum(f[Actual])/List.Sum(f[Weight])*k[Weight]),Currency.Type)
in
#"Added Custom"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.
São três tabelas
Tabelas reclamações com os a quantidade de reclamações por dia
Tabela calendario
Tabela fator (0.3, 0.38, 0.2, 0.09)
Estes valores são alterados anualmente, eles estão em uma tabela
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
98 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
157 | |
101 | |
60 | |
43 | |
40 |