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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
joshua1990
Post Prodigy
Post Prodigy

Project Value between to dates

I have a simple table that shows me a value per Article

ArticleValueDate
A100001.01.2021
A105001.02.2021

 

As you can see, each value gets a new value per month.

Now I would like to fill the timeframe between both dates based on the latest value = 1000.

How can I project - using a Dax measure - the first value from 01.01.2021 until 31.01.2021?

 

4 REPLIES 4
Jihwan_Kim
Super User
Super User

Picture1.png

 

 

https://www.dropbox.com/s/0mawaif2buhhv1n/joshuav3.pbix?dl=0 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Thanks, but the value should be flat based on the latest value. 

Picture1.png

 

https://www.dropbox.com/s/0mawaif2buhhv1n/joshuav3.pbix?dl=0 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


amitchandak
Super User
Super User

@joshua1990 , Create a date date table .

Create a new end date column

 

end date   =

minx(filter(Table, Table[Article] = earlier(Table[Article] ) &&  Table[Date] >earlier(Table[Date])),Table[Date])

rename date as start date in table 

 

then create a table

filter(Crossjoin (Table, Date), [Date] >=[Start Date] && [Date] <=[End Date])

 

A similar example in the attached file

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors