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.
In my previous help request, we found the solution, and I was able to replicate this process with other tables successfully. For some reason, though, I'm having trouble replicating this same process to a third table, Data Here. Maybe I've been looking at it too much to not be able to see the simple problem (hopefully it's an easy fix) and thought maybe someone from the PBI community could spot it:
% Exp Sum is not necessary, i think, since the custom column of % Expense exists.. I was just trying to copy the other solutions*
% Exp Sum = SUM(T_Revenue_Expense_Data[% Expense])
% Exp 5W Avg 2 = calculate( AVERAGE(T_Revenue_Expense_Data[% Exp Sum]) , DATESINPERIOD ( T_Revenue_Expense_Data[Date], LASTDATE ( T_Revenue_Expense_Data[Date].[Date]), -35, DAY ) )
I'm trying to create an average of the last 5 weeks expense to revenue ratio/percentage..
I want to make it look like this:
Any details will help.
Thank you!
Solved! Go to Solution.
Try
% Exp Sum = SUMX ( FILTER ( T_Revenue_Expense_Data, T_Revenue_Expense_Data[Date] = EARLIER ( T_Revenue_Expense_Data[Date] ) ), T_Revenue_Expense_Data[% Expense] )
% Exp 5W Avg 2 = AVERAGEX ( FILTER ( T_Revenue_Expense_Data, T_Revenue_Expense_Data[Date] >= EARLIER ( T_Revenue_Expense_Data[Date] ) - 35 && T_Revenue_Expense_Data[Date] <= EARLIER ( T_Revenue_Expense_Data[Date] ) ), T_Revenue_Expense_Data[% Exp Sum] )
Try
% Exp Sum = SUMX ( FILTER ( T_Revenue_Expense_Data, T_Revenue_Expense_Data[Date] = EARLIER ( T_Revenue_Expense_Data[Date] ) ), T_Revenue_Expense_Data[% Expense] )
% Exp 5W Avg 2 = AVERAGEX ( FILTER ( T_Revenue_Expense_Data, T_Revenue_Expense_Data[Date] >= EARLIER ( T_Revenue_Expense_Data[Date] ) - 35 && T_Revenue_Expense_Data[Date] <= EARLIER ( T_Revenue_Expense_Data[Date] ) ), T_Revenue_Expense_Data[% Exp Sum] )
Thank you!!
For educational purposes, was there a specific reason why the method I was trying to use didn't work like it did in the other tables?
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |