Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

write a measure to bring a specific value based on date

 

Hello Everybody

 

How do I write a measure which brings the value (a number) from a column in a table based on todays date? Unfortunately I can't seem to insert the table on here for you to see- the post keeps telling me I have inserted invalid HTML- whatever that means.

Sorry this is a bit vague without the table

 

Thanks

 

Claire

 

 
 
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may create measure like DAX below.

     

    Measure1= CALCULATE (FIRSTNONBLANK ( Table1[Number], 1 ),FILTER ( ALLSELECTED( Table1), Table1[Date] = TODAY() ))  

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

2 Replies