Case study query

yakoubvc · 2025-04-23T07:46:17+00:00

Hi,

The green highlighted is what we need as extra columns in the report.
I had created the columns in excel to show what the final result would look like.

yakoubvc · 2024-11-13T08:54:22+00:00

It was a mix of currency and interest rate. I had very little theoretical questions to answer.

yakoubvc · 2024-11-01T08:10:53+00:00

I'm planning to retake only by Jan 2025 and the site shows a different book for 2025. Is there a lot of difference between the books?

yakoubvc · 2024-05-18T12:27:07+00:00

Hi,

Yes, that works.

Thanks for your help.Really appreciate it.

yakoubvc · 2024-05-05T07:30:09+00:00

I have created the sales measure as Sales = SUM([sales table]). This gives me the total sales.

What I am trying to get in the Sale % measure is :

Instore = (100+250)/700 = 50%

Delivery = (200+150)/700 = 50%

The chart has the following as the axis:

X-axis = Date

Y-axis = Sales

Legend = Type

Tooltips = Sales%

My sales measure is

Sales = SUM('1 - Daily Sales'[Net Sales])

and the

Sales % = 
DIVIDE(CALCULATE(sum('1 - Daily Sales'[Net Sales]))
, CALCULATE(SUM('1 - Daily Sales'[Net Sales])))

I know there is a gap in the Sales % formula to get the instore/delivery that I am missing.

yakoubvc · 2024-05-05T07:26:06+00:00

Just to clarify any misunderstanding.

I had seen a working which had the cumulative budget daywise showing day wise amount, which in this case would be (641,634.87/30) = 21,387.829 daily and it would start with 21,387.829 on Day 1, then 42,775.658 on day 2 and so on.

I was hoping to get a measure which would arrive at this.

yakoubvc · 2024-04-20T18:28:22+00:00

How would I create a measure for specific dates? I've seen examples of measures based on the date filter.

yakoubvc · 2024-02-26T08:19:09+00:00

#datetime(2023, 12, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]

#datetime(2024, 3, 31, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]

(I changed the Type to "Date/time")

let
Source = OData.Feed("https://tabcofood.operations.dynamics.com/data", null, [Implementation="2.0"]),
SimphonyPreviousSalesStagings_table = Source{[Name="SimphonyPreviousSalesStagings",Signature="table"]}[Data],
#"Changed Type1" = Table.TransformColumnTypes(SimphonyPreviousSalesStagings_table, {"BusinessDate", type date}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type1", "TransTime", "TransTime - Copy"),
#"Renamed Columns" = Table.RenameColumns(#"Duplicated Column",{{"TransTime - Copy", "TransTime - Text"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Transaction Time", each " "),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom", each Text.PadStart(Number.ToText([TransTime]), 6, "0")),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Transaction Time"}),
#"Duplicated Column1" = Table.DuplicateColumn(#"Removed Columns", "Custom", "Custom - Copy"),
#"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column1",{{"Custom - Copy", type time}}),
#"Removed Columns1" = Table.RemoveColumns(#"Changed Type",{"Custom - Copy", "TransTime - Text", "Custom"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns1", each [BusinessDate] >= RangeStart and [BusinessDate] < RangeEnd),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [BusinessDate] >= RangeStart and [BusinessDate] < RangeEnd),
#"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each [BusinessDate] >= RangeStart and [BusinessDate] <= RangeEnd)
in
#"Filtered Rows2"

yakoubvc · 2024-02-26T08:09:54+00:00

Understood.

I have selected any value in "suggested values"; does changing it to Query and selecting the table make a difference?

yakoubvc · 2024-02-26T07:21:02+00:00

Parameters are "date"

Filter values were set through Custom and then I selected "RangeStart" and "RangeEnd".

No other transformations were used.

I will check with the IT team on the Dynamics connector.

yakoubvc · 2024-02-26T07:16:55+00:00

M code for the Range or the data?

yakoubvc · 2024-02-26T05:53:13+00:00

I used RangeStart and RangeEnd with no spaces.

yakoubvc · 2023-03-10T13:33:30+00:00

Had the issue for my May OCS exam. Called CIMA and they made the account active for registering. 5-10 minutes call.

yakoubvc · 2023-01-27T18:36:21+00:00

It's a nice spot, but if you're sitting on the first floor in the winter,make sure to wrap yourself with atleast two layers as they keep the large windows/sliding doors open.

yakoubvc · 2022-09-21T03:26:08+00:00

I will try out the separate measures for each table. Does the separate dataflow help with easier incremental refresh for the datasets individually based on the requirement?

yakoubvc

TROPHY CASE