March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I want to compare the values for the week of January 1st with the week of February 1st, does anyone know of a function that solves this?
Solved! Go to Solution.
@GabrielRF You can find the first week of the month by doing something like this:
Measure =
VAR __FWJan = WEEKNUM( DATE( 2024, 1, 1 ) )
VAR __FWFeb = WEEKNUM( DATE( 2024, 2, 1 ) )
VAR __Jan = SUMX( FILTER( 'Table', WEEKNUM([Date]) = __FWJan ), [Value] )
VAR __Feb = SUMX( FILTER( 'Table', WEEKNUM([Date]) = __FWFeb ), [Value] )
VAR __Result = __Feb - __Jan
RETURN
__Result
@GabrielRF You can find the first week of the month by doing something like this:
Measure =
VAR __FWJan = WEEKNUM( DATE( 2024, 1, 1 ) )
VAR __FWFeb = WEEKNUM( DATE( 2024, 2, 1 ) )
VAR __Jan = SUMX( FILTER( 'Table', WEEKNUM([Date]) = __FWJan ), [Value] )
VAR __Feb = SUMX( FILTER( 'Table', WEEKNUM([Date]) = __FWFeb ), [Value] )
VAR __Result = __Feb - __Jan
RETURN
__Result
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
21 | |
14 | |
11 | |
8 | |
5 |
User | Count |
---|---|
26 | |
21 | |
20 | |
14 | |
10 |