Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
109 | |
94 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |