Based on values in column – PackingList, I wish to create another column with values:
Asia, Europe, Cancelled. If value starts with digit “66” wish to return in new column “Asia”,
if starts with anything else than 66 return “Europe” but if no value on PackingList wish to return string “Cancelled”.

Based on values in column – PackingList, I wish to create another column with values:
Asia, Europe, Cancelled. If value starts with digit “66” wish to return in new column “Asia”,
if starts with anything else than 66 return “Europe” but if no value on PackingList wish to return string “Cancelled”.

I would like to resolve this issues.
I have a table with columns name’s Table1[Time_Code] and Table1[Fact_Value], the issue is when I try to identify Max Table1[Fact_Value] sometime where are lot of Max value in the same columns, me I wouldlike juste to print Max Table1[Fact_Value] corresponding to latest Table1[Time_Code].

I would like to resolve this issues.
I have a table with columns name’s Table1[Time_Code] and Table1[Fact_Value], the issue is when I try to identify Max Table1[Fact_Value] sometime where are lot of Max value in the same columns, me I wouldlike juste to print Max Table1[Fact_Value] corresponding to latest Table1[Time_Code].

I am currently facing difficulties creating a DAX measure(or python script, or something else) to calculate the local distance between the most recent activity and the previous one, with all the data already present in a single table. Despite extensive research, all the examples I’ve found involve two tables, which doesn’t apply to my situation.

I have a two dummy tables that look like:

“Hello, how can I calculate an employee’s working hours per day, month, or week when I have the following data? The userid represents the employee ID and checktime is the date and time of their clock-in and clock-out, both stored in the same column.

How can I create a dimension in Power BI that changes relative to selected condition. In this very case if a share of SKU is less then 10% out of total it gets a new name “other”. I belive this can be done in Qlik with aggr to return an array of values from a virtual table. Does Power BI allow such a thing?

A Power Query / BI newbie here. I have the following sample data table:

A Power Query / BI newbie here. I have the following sample data table: