Forum Discussion

iradann's avatar
iradann
Regular Visitor
9 years ago

Time period

  Hi! Can`t solve the problem: I need to create a calculated column that includes campaings periods in "dd.mm.yyyy - dd.mm.yyyy" format.   I have  dim_dates table  that has a lot of  information ...
Need Help
iradann's avatar
iradann
Regular Visitor
9 years ago

I have created a calculated column Period= CALCULATE ( FORMAT ( MIN ( dim_dates[date] ); "dd.mm.yyyy" ) ) & " - " & CALCULATE ( FORMAT ( MAX ( dim_dates[date] ); "dd.mm.yyyy" ) )

but it doesnt work quite right. 
In the table view it shows me the result as in the photo for one campaing, instead of one row with 11.06.2017-14.06.2017

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

 

Desired Output=CALCULATE(MAX([Check]),

                                                    FILTER(Table1,[Name]=EARLIER([Name]))

                                                    )

 

Here's a model of a Max creation that maybe helps you craft your design

 

I would do Max and Min in separate fields at first - they may be useful by themselves for other purposes in the long run - and then you can make a 3rd field that is them together as you seek.....