Forum Discussion
Fixed or static column in table
Hi everyone
I hope you all have a good day at the office
I have a table which consist of financial data, and I would like to have one or two fixed columns in the table. The other columns should be able to change.
I have yet to find a solution, do any of you know how to do it?
Hi Anonymous ,
You can create dynamically changing values directly with functions like today(), now(). For example, for now(), every time you perform a refresh, the calculated column will display the current time and date.
after refresh:
Alternatively, you can create different calculated columns based on other filtering criteria, such as:
Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2013)Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2014)
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , You can create new column in power query or dax
DAX new column
Val1 =10
Today1 = today()
If this does not help
Can you share sample data and sample output in table format? 
v-henryk-mstfCommunity Support
Hi Anonymous ,
You can create dynamically changing values directly with functions like today(), now(). For example, for now(), every time you perform a refresh, the calculated column will display the current time and date.
after refresh:
Alternatively, you can create different calculated columns based on other filtering criteria, such as:
Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2013)Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2014)
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
