Posted on:

30 Jun 2023

0

Interactive filter

This formula in excel spreadsheet is beoing used in power bi dashboard to display output =IF(ABS(H2-I2)>=MAX(Data!$N$1,Data!$O$1/100*Actual_Quantity!J2),TRUE,FALSE)) where $N$1 and $O$1 are currently hard coded or are fixed refrence point.. as per requirement from users, these should be available to update as per user wish in dashboard.... 


so currently $N$1 = 10 and $O$1 = 5%... requirement is user should be able to select any value eg. $N$1 = 0-999999 AND $O$2 = 0% to 100%


Pleae guide which functions are to be used (Measure, calculate and selectedvalue, divide etc ) to get correct calculation 

0 answers ( 0 marked as helpful)

Submit an answer