I have the following problem, I have a large spreadsheet with counts of items sold YTD - year selected using a Year slicer. This all works fine. However, the recording window for one item has been changed to now be 1st July until 31st June instead of 1st Jan - 31st Dec like all the other sales.
How would I alter my DAX count code to look backwards and count not just this year as given by the slicer, but also count any Bus's sold from the 1st of the 7th month in the previous year? Sample Excel File
This post is cross posted to the PowerBI forums DAX formula to include count from certain months onwards in a previous year and add to YTD
How would I alter my DAX count code to look backwards and count not just this year as given by the slicer, but also count any Bus's sold from the 1st of the 7th month in the previous year? Sample Excel File
This post is cross posted to the PowerBI forums DAX formula to include count from certain months onwards in a previous year and add to YTD
