Forum Discussion

IamTDR's avatar
IamTDR
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Help 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...
Need Help
  • IamTDR's avatar
    IamTDR
    6 years ago

    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.
     
IamTDR's avatar
IamTDR
Icon for Responsive Resident rankResponsive Resident
6 years ago

Thanks for the reply, for now I'm going to go with the model as is. I tested a number of products in excel and everything seems to be working as expected.

Thank you for the offer to help.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Any time!