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 Guys
Hoping you can maybe help. Im new to Power BI, and I have been working on some dashboard to help calculate the % shift of sales day on day.
I have got it working to an extent by getting the previous dates value and working out the percentage diff between that and the current value. As the dates are not continious (working days only) it doesn't fully give me what im after.
Using the Dateadd function I have been able to return everything that is minus 1 day, but i would like it to return the value for the previous date regardless if it is continious date value.
Prv Day Unused Limit = CALCULATE([Total Unused Limit],DATEADD(CARDS_DATES_POWERBI[date],-1,DAY))
Any thoughts?
Solved! Go to Solution.
Hi @imcdonald83,
Sorry for my mistake. Rather than a measure, we should create a calculated column using:
Pre = CALCULATE([Sales],CARDS_DATES_POWERBI[Date]=EARLIER(CARDS_DATES_POWERBI[predate]))
Regards,
Yuliana Gu
Today when I use your solution, it doesn't work
Yes, it didnt work for me either.
@eric98 create another post describing what you're trying to accomplish. Include lots of details and provide some sample data for people to work with.
Hi @imcdonald83,
In your scenario, please first create a calculated column:
predate = CALCULATE ( MAX ([Date] ), FILTER ( CARDS_DATES_POWERBI, CARDS_DATES_POWERBI[Date] < EARLIER ( CARDS_DATES_POWERBI[Date] ) ) )
Then, create a measure:
Pre = CALCULATE([Sales],CARDS_DATES_POWERBI[Date]=EARLIER(CARDS_DATES_POWERBI[predate]))
Best regards,
Yuliana Gu
The creating of the predate column works fine, but the Earlier function is not recognising predate as part of a measure.
EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
Hi @imcdonald83,
Sorry for my mistake. Rather than a measure, we should create a calculated column using:
Pre = CALCULATE([Sales],CARDS_DATES_POWERBI[Date]=EARLIER(CARDS_DATES_POWERBI[predate]))
Regards,
Yuliana Gu
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |