Forum Discussion
Solved
Help in calculating total
Hi Guys, I am looking for some help on one of the DAX calculation. Below is the sample data Version Month Value FY Jan-23 $ 92,447 FY Feb-23 $ 8,74,925 FY Ma...
itsmeanuj Try something like:
FY_IP_DIff Q1 = VAR __table = SUMMARIZE( FILTER('2023 Data', [Month] IN { 1, 2, 3 }), [Time Period], "__value", abs([Sum_of_Actuals]-[Sum_of_IP])) RETURN IF(HASONEVALUE('2023 Data'[Time Period]),abs([Sum_of_Actuals]-[Sum_of_IP]),SUMX(__table,[__value]))
itsmeanuj Try something like:
FY_IP_DIff Q1 =
VAR __table =
SUMMARIZE(
FILTER('2023 Data', [Month] IN { 1, 2, 3 }),
[Time Period],
"__value", abs([Sum_of_Actuals]-[Sum_of_IP]))
RETURN
IF(HASONEVALUE('2023 Data'[Time Period]),abs([Sum_of_Actuals]-[Sum_of_IP]),SUMX(__table,[__value]))
Thank you so much Greg_Deckler . I am new to PBI and need help on one more visual. Posted another query here - https://community.powerbi.com/t5/Desktop/Difference-between-2-bars/m-p/3135206#M1060479