Forum Discussion

gtamir's avatar
gtamir
Icon for Post Patron rankPost Patron
7 years ago

Mechanism to enter data to formula

HI, I made a formula to enter a value in F SCORE column acording to the value in Frequency.

Is there any way to create a window that I can key in the required valiues for the formula and the data in F SCORE column will change dinamicaly. 

Something like varibles. 

 

Thanks Giora

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    gtamir,

    I am not very clear about that how you would like to change the F score column dynamically with variables. But in Power BI Desktop, you can use variable in DAX, in this case, you would need to create a  measure instead of column to calculate F score. Once you change values in slicer or filters, the measure value will get changed accordingly.

    If you still have questions, please elaborate more about the above requirement.

    Regards,
    Lydia

    • gtamir's avatar
      gtamir
      Icon for Post Patron rankPost Patron
      7 years ago

      Anonymous

       

      If I bring the table to the visuales, I want a mean to dainamicly change the condithion for F SCORE. I want to key in 1 to 6 and see the the column F SCORE changes.

       

      Thanks Giora