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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.