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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Using Slicer date value in dax expression

Hi Everyone,
I am having a trouble to solve a situation. i have a slicer with month names from a table named as 'A sheet'. Moreover I also have date coloumn within same table from where i extracted those month names.
Now what i wanted to do is to select multiple months from slicer and use the month number of selected months in a measure for making farmula in dax.


I am new to power bi and i would greatly appriciate your help.

3 REPLIES 3
Fowmy
Super User
Super User

@Anonymous 

You can use get the months selected and incorporate in a formula, this returns a single-column table for you to work with 

VALUES('Calendar'[MonthNo])

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Thank you for your help. 
Your expression is allowing me to select one value from slicer and let me use it in farmula sucessfully however i want to select multiple values from slicer and use month number in farmulas and show it in table but in trying to do so it gives me the error.
I am using the farmula:

Dissemination | Desired = sum('Combined query'[outstanding])/12+SUM('Combined query'[outstanding])/12*(VALUES('A Sheet'[Date].[MonthNo])-1)-sum('Combined query'[Dissemination])



image_2020-10-07_091923.png

 

@Anonymous 

Can you explain what your formula is supposed to calculate?
I see you have deducted 1 from the month number, you need to iterate each month number and calculate.

Share sample data and the expected results.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors