start

4 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
How to start using PowerBI and create own scenario?
Hello, Im a beginner PowerBI user and I would like to create the simplest reporting system but Im not sure how... I want create the simplest reporting system with data to be retrieved from the company's data base. I want the report to be refreshed once a week and shown on the tv in office. I would like to know: - What do I need to create this scenario? (new pc? new server? some licence? some hardware?) - PowerBI Desktop is required to publish report? - Is it possible to publish reports via a website? - Can I install PowerBI Desktop on Linux systems? Im sorry if I made some mistakes. Please be understanding. Have a good day! Regards Daniel
Daniel_No1
7 years ago Place Report Server
709Views
0likes
0Comments