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 Monring experts!
I need help bucause I don't manage to create the mesaure in object.
I have a table with all days of week and i need to "sum" saturday and sunday on monday. I try with the suggestion in this tread https://community.powerbi.com/t5/Desktop/Sum-weekend-values-on-monday/td-p/189506 but it doesn't work.
Can we help me? I atttach the image
thank you
fil
Solved! Go to Solution.
Hi and thank you for your answer!!
I have a problem with this peace of DAX:
FILTER ( ALLSELECTED ( Table ), YEAR ( Table[Date] ) = YEAR ( currdate ) && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 )
When I write the YEAR DAX I can't insert table date. Is it normal????
Hi @filippoalicicco,
>>When I write the YEAR DAX I can't insert table date. Is it normal????
Can you please share more detail? BTW, my formula is a measure. Which connection mode you test, is it direct query?
Regards,
Xiaoxin Sheng
Hi @filippoalicicco,
You can consider to use if statement with weekday function to get current date, then use it to filter and summary record.
Summary on Monday = VAR currDate = MAX ( Table[Date] ) RETURN IF ( WEEKDAY ( currDate, 2 ) = 1, CALCULATE ( SUM ( Table[Amount] ), FILTER ( ALLSELECTED ( Table ), YEAR ( Table[Date] ) = YEAR ( currdate ) && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 ) ) ), SUM ( Table[Amount] ) )
Regards,
Xiaoxin Sheng
Hi @v-shex-msft
Is it possible to do this as a column?
This is almost exactly what I have been hunting for, but I want to be able to look at this as a trend.
Hi and thank you for your answer!!
I have a problem with this peace of DAX:
FILTER ( ALLSELECTED ( Table ), YEAR ( Table[Date] ) = YEAR ( currdate ) && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 )
When I write the YEAR DAX I can't insert table date. Is it normal????
Hi @filippoalicicco,
>>When I write the YEAR DAX I can't insert table date. Is it normal????
Can you please share more detail? BTW, my formula is a measure. Which connection mode you test, is it direct query?
Regards,
Xiaoxin Sheng
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |