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
CahabaData's avatar
CahabaData
Memorable Member
9 years ago

Generically speaking; with the tables correctly joined one can create:

 

Campaign   Min(Date)    Max(Date)

 

You can do this at the table level, via a calculated table/field if you want to establish that permanently for other uses - or - the table visual will give you this as a presentation, by dragging the Date field twice and using the field setting options.

 

Date formating option is available in Modeling in the ribbon as a selection and if you need something more unique that isn't offered there then one would use a Dax format statement via measure or calculated field.

 

 

 

 

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.....