Forum Discussion
Dynamic Calculated Columns using What If Parameter
It can be only used in measures not in columns. You can add a measure for you date calculation and use that.
here is the link to pbix
Feel free to change calcs as you see fit. all the measure starts with x are the calculated measures.
All there is paramter for path of excel file which you can change to point to you excel file.
this is very elaborate and helpful.
Although i am trying to do the same with a a range of decimal values instead of date i.e.
a what if paramter created threshold - 0 to 1 with increment 0.1.
my calculated field
x threshold_test2 = if(HASONEVALUE(thresh_test_2[threshold]),VALUES(thresh_test_2[threshold]),0.5) always returns the default 0.5 even if you select any other data from splicer.
Can you please help.
Thanks
Great, thanks!
this is very elaborate and helpful.
Although i am trying to do the same with a a range of decimal values instead of date i.e.
a what if paramter created threshold - 0 to 1 with increment 0.1.
my calculated field
x threshold_test2 = if(HASONEVALUE(thresh_test_2[threshold]),VALUES(thresh_test_2[threshold]),0.5) always returns the default 0.5 even if you select any other data from splicer.
Can you please help.
Thanks
Hi parry2k
Can you please share again the PBI link? I cannot open it, and I am facing a similar issue than this post.
Thanks!
parry2k
Unable to access to the pbix file, can you reshare it
