Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mafrack
Regular Visitor

Calculate difference between selected and unselected values

Hey everyone,

 

I'm kind of new to Power BI so basically everything I know I learnt as I was doing.

Capture.PNG

I have a slicer with the dropdown option so I can select the week I want to see. Now I would like a card with the difference of quantity between the week selected and the previous week. How can I do that?

 

Thanks

1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @mafrack 

 

Check this blog post, you can find the solutions for most of your WEEKLY TIME INTELLIGENCE CALCULATIONS IN DAX:

https://www.vahiddm.com/post/weekly-time-intelligence-dax

VahidDM_0-1658231854931.png

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

Badges.jpg

LinkedIn | Twitter | Blog | YouTube 

View solution in original post

1 REPLY 1
VahidDM
Super User
Super User

Hi @mafrack 

 

Check this blog post, you can find the solutions for most of your WEEKLY TIME INTELLIGENCE CALCULATIONS IN DAX:

https://www.vahiddm.com/post/weekly-time-intelligence-dax

VahidDM_0-1658231854931.png

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

Badges.jpg

LinkedIn | Twitter | Blog | YouTube 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.