Forum Discussion
newbie7
3 years agoFrequent Visitor
Need help in adding a column in matrix visual made with measures
Hi experts, I am not able to figure it out so need help. I have a bunch of folders and queries that are being used as sources. With power query data prep and dax for calculations, i was able to cre...
newbie7
3 years agoFrequent Visitor
UPDATE:
as an alternative, I am trying to solve via using a further date like 12312400 from date table and adding a part in my measure 1 /2/3 calculation saying when Date=12312400, then 0.9 (a static value) else the sum #/A#. I can relabel column 12312400 as my target.
any suggestion if this could be worked. I am getting error as date column cant be referred because of multiple values. Also when i tried to use in calculated column instead of measure, i could not add date column in dax in another table. Any way out.
Thanks,