Forum Discussion
Lookup Value from Filter with Multiple Criteria
Hi PBI Friends, First time poster and new to DAX. I'll try to explain this as best as I can. I have a Matrix visual that currently shows budget and actual performance data by phase/actvity and th...
I've joined the Excel input variable file with the fact table (export_universal) by linking the concatenate and date field. So I'm able to verify that the sum of the phase/activity/fact table date does add up to 140.73 but how do I go about changing the expression of the visual column "UniAdj" so that I can bring in the value of the month that I select from the slicer "Fcst Date" instead of using the date from the fact table? Thanks