I searched for one project by chatgpt and it recommends to change "data type" of "new parameter" to date/time. But only number or field is possible. Is it a way to change this data type?
Great video Reza specially the dynamic title part. You gave me an idea for a report at the office where I can use the dynamic title. Thanks for posting
I have created a parameter, Parameter_For_No_Of_Apps = GENERATESERIES(1,100,1) But I really want to replace the static part of GENERATESERIES to be dynamic using an actual measure. Something like this. Parameter_For_No_Of_Apps = GENERATESERIES([NO OF RECEIVED APPS],[NO OF RECEIVED APPS]*2,1) It does not complain, though, but it does not respect the filter context. Do you know how to solve it?
Can you add additional columns into the generated table for alternative selections? I have seven metrics measured in 'Days' as compliance targets ranging from 3 to 84 days. I would like to be able to propose new values for several of the targets to compare performance with the current established targets. So the 5 day target reduced to 4 days, the 14 day target reduced to 10 days, the 21 day target reduced to 15 days etc. In your scenario I think the equivalent would be to be able to also select weeks, maybe two weeks periods etc. Or would I need to set up several What If parameter tables for each target?
You can generate a table in DAX using table constructor with as many columns you want, I have a video about table constructor. another way is to use ADDColumns
Reza, keep up your good work. Very helpful and informative especially the dynamic title part. Thank you, Reza for sharing your expertise.
I searched for one project by chatgpt and it recommends to change "data type" of "new parameter" to date/time. But only number or field is possible. Is it a way to change this data type?
Great video Reza specially the dynamic title part. You gave me an idea for a report at the office where I can use the dynamic title. Thanks for posting
Glad it was helpful!
I have created a parameter,
Parameter_For_No_Of_Apps = GENERATESERIES(1,100,1)
But I really want to replace the static part of GENERATESERIES to be dynamic using an actual measure. Something like this.
Parameter_For_No_Of_Apps = GENERATESERIES([NO OF RECEIVED APPS],[NO OF RECEIVED APPS]*2,1)
It does not complain, though, but it does not respect the filter context. Do you know how to solve it?
great tutorial for dynamic calculation. thanks
Glad it was helpful!
Can you add additional columns into the generated table for alternative selections? I have seven metrics measured in 'Days' as compliance targets ranging from 3 to 84 days. I would like to be able to propose new values for several of the targets to compare performance with the current established targets. So the 5 day target reduced to 4 days, the 14 day target reduced to 10 days, the 21 day target reduced to 15 days etc. In your scenario I think the equivalent would be to be able to also select weeks, maybe two weeks periods etc. Or would I need to set up several What If parameter tables for each target?
You can generate a table in DAX using table constructor with as many columns you want, I have a video about table constructor. another way is to use ADDColumns
Can we change the column's title dynamicly ?
Not at the moment, in the future maybe
You fan put a card visual on top of it and change that dynamically though
@RADACAD Thanks for the quick reply. I've been waiting for this feature for so many years.I am losing my hope!
Excellent 🎉.. thanks for sharing
Thanks for watching!
👌🏻