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 Community,
I have two tables T1 contains values for each store by city and date, and T2 is a date table
The problem shows up when trying to return the previous value of the store all returned values are blank
The formula used in the new calculated column is
Here is the result I am looking for
Thank you in advance.
Solved! Go to Solution.
Hi @DataVitalizer,
You can create a measure below:
Hi @DataVitalizer,
You can create a measure below:
I would suggesting visiting the community to post this in the desktop section or the Dax section as this particular site is for reporting issues with the actual product and not with a calculation.
You may want to include a little more info with the post including a snapshot or your model relationships as well in order to diagnose the calculation issue. It seems that the Dax is having an issue defining last month. It may be the relationship or the field you are adding. Your calculation references your column of [Date] but the display shows DateTable. You may want to try droping [Date] on the visual instead of DateTable.
Proud to be a Super User!
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |