Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gtamir
Post Patron
Post Patron

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

 

ScreenHunter_028.jpg

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft

 

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

 

ScreenHunter_030.jpg

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.