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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Make a column value available in a measure

Hi,
With the following post I was able to add a column to the Dates table, in order to have the number of days in the current month:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Days-in-Current-Month/m-p/1214980#M19604

Now, I would like to use this value as a variable in another measure. For example, the measure below had the number of days (30 for November) typed in manually: 

RevthisMonth-PRJNRMUsg = [RevthisMonth-MTDNRMUsg]/[Yesterday]*30

I want to replace this 30 by the variable which is now calculated in the Dates table. But don't know how to relate to it, since I can only refer to other measures, not to a specific table column, in that format. 

Thanks for your help!

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

RevthisMonth-PRJNRMUsg = [RevthisMonth-MTDNRMUsg]/[Yesterday]*max(dates[days in month])

@Anonymous 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks so much, works perfectly with this max function.

wdx223_Daniel
Super User
Super User

RevthisMonth-PRJNRMUsg = [RevthisMonth-MTDNRMUsg]/[Yesterday]*max(dates[days in month])

@Anonymous 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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