Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have matrix that has dates on columns, which are selected using a slicer and has Sales Amount as a value, and is broken down by Country on the Rows
Im wanted to create a measure that gives me the 2nd date - 1st date like below
If anybody could help Please!
@Euro0681 , Assume you are using a measure and only 2 dates are selected
then you can switch total using isinscope
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
if(isinscope(Date[Date]), [Measure],
calculate( [Measure], filter('Date', 'Date'[Date] =_min )) - calculate( [Measure], filter('Date', 'Date'[Date] = =_max)) )
if they are month
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
if(isinscope(Date[Date]), [Measure],
calculate( [Measure], filter('date',eomonth( 'date'[Date],0) =eomonth(_min,0) )) - calculate( [Measure], filter('date', eomonth('date'[Date],0) = eomonth(_max,0) )) )
When using in the matrix I get something like this
Not as i expect any suggestion?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
16 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
12 |