Forum Discussion
IamTDR
Responsive Resident
Responsive ResidentHelp w a Date Measure on Power BI Desktop
I am trying to complete a measure where I can look at the units sold, but the time period is a bit different. I would like to see the units sold after the first 6 months after launch and then see th...
Of course after posting on the forum I tried another idea that worked for me.
First I added a column to my dataset that took the ship_date_month and added 6 months to it. Then this measure worked for me.= CALCULATE(SUM('BI CompOrders_Trend_Tbl'[order_quantity]),DATESINPERIOD('BI CompOrders_Trend_Tbl'[Ship_Date_Month],FIRSTDATE('BI CompOrders_Trend_Tbl'[Ship_Date_Month_>6]),11,MONTH))Would still be interested in a measure that would be a little bit easier to use but for now this is working as I tested it in excel over a couple of products.
IamTDRResponsive Resident
Responsive ResidentOf course after posting on the forum I tried another idea that worked for me.
First I added a column to my dataset that took the ship_date_month and added 6 months to it. Then this measure worked for me.
= CALCULATE(SUM('BI CompOrders_Trend_Tbl'[order_quantity]),DATESINPERIOD('BI CompOrders_Trend_Tbl'[Ship_Date_Month],FIRSTDATE('BI CompOrders_Trend_Tbl'[Ship_Date_Month_>6]),11,MONTH))
Would still be interested in a measure that would be a little bit easier to use but for now this is working as I tested it in excel over a couple of products.
Greg_Deckler
Community Champion
Community ChampionWould be willing to take a look at it but would really appreciate some sample data or the PBIX you are working with.