Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi @all,
Is it possible to create a measure to find variance in PowerBI like below?
Hi Ashish,
Thanks for the response. Yes, the row labels are coming from the slicer and there would always be 2 dates in the row labels.
Hi,
Assuming you have a Calendar Table and the dates in the row labels are from th Calendar Table, try this DAX pattern
=calculate([Total],datesbetween(Calendar[date],MAXX(allselected(Calendar),calendar[date]),MAXX(allselected(Calendar),calendar[date]))-calculate([Total],datesbetween(Calendar[date],minx(allselected(Calendar),calendar[date]),minx(allselected(Calendar),calendar[date]))
Hi Ashish,
I really appreciate your solution. Unfortunately, I'm experiencing an error: "A function 'DATESBETWEEN' has been used in a True/False expression that is used as a table filter expression. This is not allowed"
CALCULATE ( [Net Debt], DATESBETWEEN ( DimValdate[ValDate], MAXX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ), MAXX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ) ) - CALCULATE ( [Net Debt], DATESBETWEEN ( DimValdate[ValDate], MINX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ), MINX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ) ) ) )
You are welcome. There should be another closing bracket before the - sign and remove one closing bracket from he end.
If it still does not work, then share the download link of the PBI file.
Hi Ashish,
The modified formula did work but unfortunately didn't achieve what was actually expected.
Rows: ValDate (i.e Dec & June)
Columns: Fiscal Year (FY23, FY24,....)
Value: Net Debt(measure) , Net Debt Variance
Hi,
What would the result be if there were more than 2 dates in the row labels? Also, are the row labels coming from a slicer selection?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |