Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day everyone, I'm new with Power BI just wanted to ask how can I add the distinct items from one table into another.
I wanted to save all the distinct group_items in [Items] Table to [Duration] Table and compute the total created time for each group_items. See sample image below. I've been searching all day now still no chance.
Solved! Go to Solution.
Hi @nujkram
First in query editor
add two custom columns (Add Column->Custom Column)
Custom=DateTime.Time([created]) Custom.1= #time(Time.Hour([Custom]),0,0)
Second in Data View, create two calculated columns
duration = [Custom]-[Custom.1] sumduration = CALCULATE(SUM(Sheet5[duration]),ALLEXCEPT(Sheet5,Sheet5[items]))
Second create a new table and create a calculated column in this new table
Table = SUMMARIZE(Sheet5,Sheet5[items],Sheet5[sumduration]) id = RANKX(ALL('Table'),'Table'[items],,ASC)
Best regards
maggie
Hi @nujkram
First in query editor
add two custom columns (Add Column->Custom Column)
Custom=DateTime.Time([created]) Custom.1= #time(Time.Hour([Custom]),0,0)
Second in Data View, create two calculated columns
duration = [Custom]-[Custom.1] sumduration = CALCULATE(SUM(Sheet5[duration]),ALLEXCEPT(Sheet5,Sheet5[items]))
Second create a new table and create a calculated column in this new table
Table = SUMMARIZE(Sheet5,Sheet5[items],Sheet5[sumduration]) id = RANKX(ALL('Table'),'Table'[items],,ASC)
Best regards
maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |