Rolling sales from the last 24 months
Hi, management wants to see the accumulated sales until now vs the accumulated sales from the last two years in a graphic displaying the last 24 months. I have written this measure for the rolling numbers, thinking that MAX Date was related to our current time (today). Instead, Max date looks at row level and so it computes rolling numbers backwards, which is not what we want. Sales cumulated rolling = CALCULATE ( [Total Sales], DATESINPERIOD ( 'Datetable'[Date], MAX ( 'Datetable'[Date] ), -24, MONTH )) With this, I will see the accumulated sales with May 2022 as a label but including numbers from 2020. What I need is basically the raw numbers since January 2022, accumulated. I have looked around, but I am lost. Can someone help here? Thanks! Pauline.
How to find inside a string to do time calculation
Hi everyone! I'm working with sports data, calculating the time on court for players and would like to calculate time when a specific string (player name) is inside a column. Due to the data structure, I have the info for the full FiveOnCourt and based on positions but not for a player alone. Here is the example: As you can see, I have "Player7" who played in different positions so I would like to have one only table with the following values for each player (not needed the order because it's only an example with players with more than one position): PLAYER7 - 1 - 00:17:39 (0:05:26 + 0:12:13) - 41 PLAYER13 - 1 - 0:28:40 (0:21:02 + 0:07:38) - 84 PLAYER... PLAYER... So, I guess I have to create a measure to find every string inside the FiveOnCourt but I don't know how I could do it. Could you help me, please? I add the link to the raw data and the pbix file: https://drive.google.com/drive/folders/1BxVWCtoHkcQYnDfOpqmYFpFgXpoEIPOt?usp=drive_link Thank you for your time!
Last 3 months date column using DAX in pbi, Kindly please help?
Hi Team, I am new to power bi. I have date column as like below snapshot. based on this column I need to filter last 3 months data only. By using relative date in slicer settings it will not working and not changing anything in visual level. Kindly please help me with DAX Query for last 3 months? Thanks in advance!DateDiff until end of month
Hi guys, I'm working on a table with several columns: date, product and status. Each product can have several statuses (working, not working). I'm looking to calculate how long each product stayed in a certain status. For this I have a measure that calculates for each product How long has it been until the next time it changes status and so on. BUT I have a problem the result obtained does not reflect reality. if for example a product A was "working" from 01/01/2021 until 01/05/2021 (4 days difference) in this date it will "Not working". but the 02/05/2021 it will be "working" so my measure says me that passed from here 30 days. But actually that is not true. Because if I want to display for the January month how many days was the product "not working" so I'll get the result 30 ! But the reality is that in January the product was 25 days in this status and not 30, the five days have to be in the next month ! Actually dax have to understand that he have to stop the sum of days at the end of month if not I'lol get fake data with slicers. do you have a solution ?
Restrict YTD with Max order date and keeps filter of Calender table
Hi All, how can I bring previous row value to the next row. Like in below table, i do not have value in 13th Jan, so it should show 12th Jan Value. I have using the below dax because I have to restric ytd upto the max order date. Total YTD (current) = TOTALYTD([Total sales], 'Calender Table'[Date], 'Calender Table'[Date] <= MAX(Data[Order Date]) ) Thanks.Showing logged in user Date time with Type of timezone it belongs to
Hi, In the Report, i need to show the logged in users current Datetime and type of timezone it is showing. Using DAX Now() i will get the current date and time however i am not getting whether it is EST,PST or CET timezone. I need to add timezone also to the timestamp. Please suggest if anything related to Power Query or DAX function this can be achieved. Thanks in Advance.
