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.
Hello,
I'm having a problem with SAMEPERIODLASTYEAR, when the data is not fully loaded it seems to show wrong cumulative amount.
Is there any other way rather than setting page level filter on filter pane to exclude current year month's from dax formula that doesn't have last year's comparison?
DAX:
Sameperiodlastyear = CALCUALTE ( [Total Sales], SAMEPERIODLASTYEAR ( DimDate [Date] ) )
Many thanks in advance!
Solved! Go to Solution.
Hey @Dom87326 ,
can you show which filter contexts are affecting the visual by hovering over the small filter icon like that:
For me it looks like there is a filter from October on and that's the reason the visuals shows only 7'664 instead of 37'516. Same for the total.
As an alternative, would it be possible to share the file? Then I can take a look.
Hey @Dom87326 ,
can you show which filter contexts are affecting the visual by hovering over the small filter icon like that:
For me it looks like there is a filter from October on and that's the reason the visuals shows only 7'664 instead of 37'516. Same for the total.
As an alternative, would it be possible to share the file? Then I can take a look.
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |