start

3 Topics

Extract data from start and end validity
Hi, I've got a table with product and starting/end date of marketing, like this : Product start of marketing End of marketing Produit A 01/01/2018 31/01/2018 Produit A 01/01/2019 31/01/2019 Produit A 01/01/2020 31/01/2020 Produit A 01/01/2021 31/01/2021 Produit A 01/01/2022 31/01/2022 Produit B 01/01/2018 31/01/2020 Produit C 01/01/2019 31/01/2023 I want to get this visualisation : active product discontinued product new product 2018 2 0 2 2019 3 0 1 2020 3 0 0 2021 2 1 0 2022 2 0 0 2023 1 1 0 I used a table of dates in years I used COSSSJOIN function to obtain a table with for each year the existence of the product or not. But I cannot compare and obtain the desired variations between years (discontinued products or new products)
Solved
sigtopo
2 years ago Place DAX Commands and Tips
476Views
0likes
1Comment
Find Order Duration based on Start Stop time
Hello, please can you help to find order duration based on starting and finishing time example like in column duration. Order id From To Duration 0 23:00 23:03 1306993 23:03 23:03 1306993 23:03 23:06 1306993 23:22 23:33 1306993 23:33 23:33 1306993 23:34 23:35 1306993 23:35 23:37 1306993 23:38 23:39 1306993 23:42 23:43 1306993 23:43 23:43 00:40 0 23:43 23:44 1305300 23:44 23:45 1305300 23:45 23:46 1305300 23:47 23:47 1305300 23:48 23:49 1305300 23:54 23:54 1305300 23:54 23:55 1305300 23:56 23:59 1305300 23:59 00:00 1305300 00:00 00:01 1305300 00:02 00:03 1305300 00:03 00:03 1305300 00:04 00:04 1305300 00:04 00:07 1305300 00:07 00:07 1305300 00:07 00:08 1305300 00:08 00:09 00:25 0 00:09 00:10 1307012 00:53 00:54 1307012 00:54 00:55 1307012 00:56 00:58 1307012 01:02 01:05 00:12 0 01:05 01:05 1307031 01:05 01:05 1307031 01:06 01:06 1307031 01:11 01:11 1307031 01:13 01:14 1307031 01:19 01:42 1307031 01:44 01:45 1307031 01:45 01:46 1307031 01:46 01:46 00:41
Wirestat
3 years ago Place DAX Commands and Tips
982Views
0likes
3Comments
How to Find Orders Duration based on Start Stop time
Hello, how its possible to find order duration based on starting and finishing time, for example like in column duration. Order id From To Duration 0 23:00 23:03 1306993 23:03 23:03 1306993 23:03 23:06 1306993 23:22 23:33 1306993 23:33 23:33 1306993 23:34 23:35 1306993 23:35 23:37 1306993 23:38 23:39 1306993 23:42 23:43 1306993 23:43 23:43 00:40 0 23:43 23:44 1305300 23:44 23:45 1305300 23:45 23:46 1305300 23:47 23:47 1305300 23:48 23:49 1305300 23:54 23:54 1305300 23:54 23:55 1305300 23:56 23:59 1305300 23:59 00:00 1305300 00:00 00:01 1305300 00:02 00:03 1305300 00:03 00:03 1305300 00:04 00:04 1305300 00:04 00:07 1305300 00:07 00:07 1305300 00:07 00:08 1305300 00:08 00:09 00:25 0 00:09 00:10 1307012 00:53 00:54 1307012 00:54 00:55 1307012 00:56 00:58 1307012 01:02 01:05 00:12 0 01:05 01:05 1307031 01:05 01:05 1307031 01:06 01:06 1307031 01:11 01:11 1307031 01:13 01:14 1307031 01:19 01:42 1307031 01:44 01:45 1307031 01:45 01:46 1307031 01:46 01:46 00:41
Solved
Wirestat
3 years ago Place DAX Commands and Tips
1.6KViews
0likes
7Comments