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.
Hi Experts
I have a master table was i have uploaded into POwer BI, i want to creat a summary table based on Column Time, and Obersavation count...the trick here is i want the summary table to be driving using the following DAX and add other columns to the summary table as and when required.
result table = ADDCOLUMNS ( FILTER ( CALENDAR ( MIN ( Sample1[Time] ), MAX ( Sample1[Time] ) ), DAY ( [Date] ) = 1 ), "observations", CALCULATE ( SUM ( Sample1[Observations] ), FILTER ( Sample1, Sample1[Time].[Year] = YEAR ( EARLIER ( [Date] ) ) && Sample1[Time].[MonthNo] = MONTH ( EARLIER ( [Date] ) ) ) ) + 0 )
Solved! Go to Solution.
Hi @Anonymous ,
It would be better you could provide sample data and desired output so that I can test.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Hi @Anonymous ,
It would be better you could provide sample data and desired output so that I can test.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
HI Yu Gu... I have managed to solve the problem through trial and error. Is there a way to delete the question?
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |