Forum Discussion

junyetzotomayor's avatar
junyetzotomayor
Icon for Helper I rankHelper I
9 years ago

distribute values in specific date range

Is it possible in PBI to distribute values in specific date range? Lets say I have the following records (see screenshot): Record 1 start date: january 2017 Record 2 start date: feb 2017 en...
junyetzotomayor's avatar
junyetzotomayor
Icon for Helper I rankHelper I
9 years ago

Hi GilbertQ

 

Sorry I'm new to PowerBI. Is that syntax a new column?

 

Thank you!

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi junyetzotomayor,

 

Ok if you are new, then what you would require is a Date Table, and here is a great blog post explaining.

 

Do You Need a Date Dimension?

 

Then what you need to do is once that is created, is to create a New Measure, with the Syntax I provided previously.

Please let us know if you get stuck.