Forum Discussion

powerbifuddaa's avatar
powerbifuddaa
Icon for Helper II rankHelper II
3 years ago

earliest date when using a visual

Hi there, Hope someone can help me. I made a table that shows movements of id's from segment a to b (see formula below). The startdate should be made "earliest". Works perfectly fine (270 ro...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

powerbifuddaa , Create a date table and have Month and year in that table. Create a bar visual with concatenate label off

 

Date= Addcolumns(calendar(date(2012,01,01), date(2024,12,31) ), "Month no" , month([date])
, "Year", year([date])
, "Month Year", format([date],"mmm-yyyy")
, "Month year sort", year([date])*100 + month([date])
, "Qtr Year", format([date],"yyyy-\QQ")
, "Qtr", quarter([date])
, "Month",FORMAT([Date],"mmmm")
, "Month sort", month([DAte])
, "FY Year", if( Month(([DAte])) <7 , year(([DAte]))-1 ,year(([DAte])))
, "Is Today" ,if([Date]=TODAY(),"Today",[Date]&"")
,"Day of Year" , datediff(date(year([DAte]),1,1), [Date], day)+1
, "Month Type", Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY") )
,"Year Type" , Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
)

 

 

Join with date of your table

powerbifuddaa's avatar
powerbifuddaa
Icon for Helper II rankHelper II
3 years ago

Thanks amitchandak 

My problem is that I have to work in my vendor's analysis services surroundings so I only have DAX (no power query, no create table options).

So, my challenge is particularly that with the "earliest" date, the "earliest" mutation is picked (270) and not all mutations what happens if I "don't summarize" (1156).