Forum Discussion
table filter not working with me Measure
Hi,
I'm new power BI and have written out the following DAX expression in a measure:
Spending in last year=
CALCULATE([total expenditure], DATESINPERIOD('FY Lookup' [start of month].[date],MAX('FY Lookup'[start of month]),-1,YEAR
The figure seems to be correct but doesn't seem to work when i put this figure in a table with the the fund number. Some funds seem to display incorrect values for "Spending in last year". Is this because i need to use an iterator function instead? If so, how would i write it?
Any help would be really appreciated. Thanks!
1 Reply
Hi badatBI ,
Please share the sample data, the expected outputs and the measure formula you are using.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Best Regards,
Wearsy
