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 know this kind of problem is described in the forum quite many times, but i can't seem to find a solution to fix my issue.
So basically the table total is wrong.
The measure I am trying to sum is: Sales LY = calculate(sum(Table1[Sales EUR]);SAMEPERIODLASTYEAR(Departure_date[Departure Date]);FILTER(SAMEPERIODLASTYEAR(Issued_date[Sales Date]);Issued_date[Sales Date]<=(max(Table1[Issued Calendar Date])-[LAG]))).
In Table1 I have several other measures which I am using to filter the data. For example:
Any ideas how to fix it? I suppose I would need to add something to the measure I am using?
Thanks for the help!
Hi @catleen,
I notice there are three tables Table1, Departure_date, Issued_date used in the measure, would you please share some dummy data about this three tables and expected results for us to test it?
Best Regards,
Qiuyun Yu
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |