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.
Dear All, I´m new here and I´m new with Power BI.
I´m making my first dashboard and I have the following problem.
In my dashboard, I have a Slicer with date and that slicer control the Sales ammount (Sales[Ammount]).
I want to get the difference between these two dates selected in this slicer no matter if this are consecutive or not.
Is it possible ?
Thanks
Solved! Go to Solution.
Hi @gustavo468 ,
You can create a measure as below to get it, please find the details in the attachment.
Difference =
VAR _maxdate =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
VAR _secondmdate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] < _maxdate )
)
VAR _mamount =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER ( 'Table', 'Table'[Date] = _maxdate )
)
VAR _smamount =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER ( 'Table', 'Table'[Date] = _secondmdate )
)
RETURN
_mamount - _smamount
If the above one is not working for you, please provide some sample data(exclude sensitive data) with Text format and your expected result with special examples and screenshots. It is better if you can provide me a simplified pbix file. Thank you.
Best Regards
Sorry, the difference between the ammount sales for those dates. Thanks
Hi @gustavo468 ,
You can create a measure as below to get it, please find the details in the attachment.
Difference =
VAR _maxdate =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
VAR _secondmdate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] < _maxdate )
)
VAR _mamount =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER ( 'Table', 'Table'[Date] = _maxdate )
)
VAR _smamount =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER ( 'Table', 'Table'[Date] = _secondmdate )
)
RETURN
_mamount - _smamount
If the above one is not working for you, please provide some sample data(exclude sensitive data) with Text format and your expected result with special examples and screenshots. It is better if you can provide me a simplified pbix file. Thank you.
Best Regards
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |