User Profile
dolevh
Helper II
Joined 5 years ago
User Widgets
Contributions
create a new table with min date of price column
Hi all, I have this table: Table Name: Customers ID Date Price 123 1/1/2021 Blank 123 2/1/2021 0 123 3/1/2021 100 123 4/1/2021 200 321 1/1/2021 99,999,999 321 2/1/2021 50 45678 1/1/2021 Blank 45678 2/1/2021 0 45678 3/1/2021 1,000 and now, I want to create a new table that shows me just the unique ID with the first price that is greater than 0 and less than 2M. Table Name: CustomersUniqueValue ID Date Price 123 3/1/2021 100 321 2/1/2021 50 45678 3/1/2021 1,000 how can I create just the column Price with the Min Date that the first price is greater than 0 and less than 2M?Solved1KViews0likes3CommentsSum of rows per ID and then Avg of All
Hi All, I have this table : ID StartDate EndDate Price CountofNum 123 1/1/21 1/31/21 9999 123 2/1/21 2/28/21 10 1 123 3/1/21 3/31/21 10 0 123 4/1/21 4/30/21 10 0 123 5/1/21 5/16/21 9999 12345 1/1/21 1/31/21 9999 12345 2/1/21 2/28/21 9999 12345 3/1/21 3/31/21 20 1 12345 4/1/21 4/30/21 20 0 12345 5/1/21 5/31/21 20 0 12345 6/1/21 6/30/21 20 0 123456789 1/1/21 1/31/21 1 123456789 2/1/21 2/14/21 9999 I'm looking for dax that shows me the average of all rows that the value in the Table[CountofNum] column is '1' or '0' per ID. For example: ID SumOfData 123 1 + 0 + 0 = 3 12345 1 + 0 + 0 + 0 = 4 123456789 1 = 1 and then, Table[SumOfData] / Table[ID] (3 + 4 + 1) / 3 '3' is beacuse the ID unique. thanks!Solved758Views0likes3Comments- 1.3KViews0likes1Comment
SUMMARIZE with COUNTROWS and FILTERS
Hi All, I have this table (CusTable) : RecordID Date NewColumn 123 1/1/2022 1 123 2/1/2002 0 123 3/1/2022 0 123456 1/1/2022 1 123456 2/1/2002 0 123456 3/1/2022 0 123456 4/1/2022 0 123456789 1/1/2022 1 123456789 2/1/2002 0 234 1/1/2022 1 567 1/1/2022 1 I'm looking for dax that shows me if any RecordID has the num "0" so counting them but only one time. for example in my table counting the num is "3" thanks all!Solved1.3KViews0likes3CommentsRe: a new column in modeling with aggregation
and if I want to do a column that shows me just if the 'price' is not null and the 'CountofNum' is 1 and the id appears the first time like this : ID StartDate EndDate Price CountofNum 123 1/1/21 1/31/21 20 1 123 2/1/21 2/28/21 10 0 123 3/1/21 3/31/21 10 0 123 4/1/21 4/30/21 10 0 123 5/1/21 5/16/21 12345 1/1/21 1/31/21 12345 2/1/21 2/28/21 12345 3/1/21 3/31/21 20 0 12345 4/1/21 4/30/21 20 0 12345 5/1/21 5/31/21 20 0 12345 6/1/21 6/30/21 20 0 123456789 1/1/21 1/31/21 50 1 123456789 2/1/21 2/14/21 50 0 do you have solution for this? thanks so much 🙂703Views0likes0Commentsa new column in modeling with aggregation
Hi All, I have this table: ID StartDate EndDate Price 123 1/1/21 1/31/21 123 2/1/21 2/28/21 10 123 3/1/21 3/31/21 10 123 4/1/21 4/30/21 10 123 5/1/21 5/16/21 12345 1/1/21 1/31/21 12345 2/1/21 2/28/21 12345 3/1/21 3/31/21 20 12345 4/1/21 4/30/21 20 12345 5/1/21 5/31/21 20 12345 6/1/21 6/30/21 20 123456789 1/1/21 1/31/21 123456789 2/1/21 2/14/21 I need a table with a new column (CountofNum) : - If the price is not empty it appears for the first time in each ID card so Table[CountofNum] = '1' - If the price is not empty and it appears a second or more time in each ID then Table[CountofNum] = '0' - else null for example: ID StartDate EndDate Price CountofNum 123 1/1/21 1/31/21 123 2/1/21 2/28/21 10 1 123 3/1/21 3/31/21 10 0 123 4/1/21 4/30/21 10 0 123 5/1/21 5/16/21 12345 1/1/21 1/31/21 12345 2/1/21 2/28/21 12345 3/1/21 3/31/21 20 1 12345 4/1/21 4/30/21 20 0 12345 5/1/21 5/31/21 20 0 12345 6/1/21 6/30/21 20 0 123456789 1/1/21 1/31/21 123456789 2/1/21 2/14/21 Thanks All!Solved757Views0likes3CommentsRemove the display of months June 22 until December 22
Hi, I have data until the end of 2022 but I want to present the data until today (May 2022) this is my dax : Cumulative ProjectTable = VAR ABV = CALCULATE ( LASTDATE( ProjectTable[date] )) RETURN IF( SELECTEDVALUE('Date'[Date]) > TODAY(), BLANK(), CALCULATE(COUNT(ProjectTable[id]), 'ProjectTable'[active] = 1, FILTER( ALLSELECTED('Date'), 'Date'[Date] <= MAX('Date'[Date] )))) But on visualization, it looks like this: Which Dax do I need to take off the months of June 22 until December 22? thanks all!Solved669Views0likes3CommentsM code with max date
Hi, I have a Customers table: Date Year Month RecordID Custom 1/1/2022 2022 01 123 1/20/2022 1/3/2022 2022 01 123 1/20/2022 1/9/2022 2022 01 123 1/20/2022 1/14/2022 2022 01 123 1/20/2022 1/20/2022 2022 01 123 1/20/2022 I want to add Customers[Custom] like if Year = Year and Month = Month and RecordID = RecordID so bring me the max date in this month for my example it: 1/20/2022 thanks all!Solved984Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.