Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm currently having an issue with a measure on a line chart and when I try to run a filter, it just disappears.
I created a measure as follows:
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
SAMEPERIODLASTYEAR works best with a Date table, so create a date table (with a date column and year column), link it your fact table, and replace any field in the visuals with appropriate fields from the date table.
Change the measure to :
Measure15 = CALCULATE(SUM('Table (2)'[Budget total]), SAMEPERIODLASTYEAR(TableDates[Date]))
Good luck.
SAMEPERIODLASTYEAR works best with a Date table, so create a date table (with a date column and year column), link it your fact table, and replace any field in the visuals with appropriate fields from the date table.
Change the measure to :
Measure15 = CALCULATE(SUM('Table (2)'[Budget total]), SAMEPERIODLASTYEAR(TableDates[Date]))
Good luck.
Hi,
You may download my PBI file from here.
Hope this helps.
Brilliant, thank you.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |