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...
PaulDBrown
Community Champion
3 years agoWill the measures always de referencing the current month (sep 2022) or does it need to be dynamic?
Also, can you expand on what the measures are calculating?
newbie7
3 years agoFrequent Visitor
thanks, The measure are calculating monthly values based on month end dates in the data source and all data sources are connected with date table 1:1. and the matrix has date from date table and measure # from each month. will be dynamic , so matrix will show past rolling 9 months.
in my date table last date is 12312400. so i was thinking if any way i can add the condition in my measure calculation like if date=12312400 then show 0.9 else show measure calculation, then i can use 12242400 month as target in visual.