Forum Discussion
How to get same month last year data to populate when using a second date drilldown?
Hi, I am attempting to build a PBI that looks at ordering data based on the date an order was created, but I want to see the month that it was billed in. My 'This Year' data is correct, but my 'L...
sergej_og
Super User
Super UserIf i have understood the case correctly then it is a case for USERELATIONSHIP to CALCULATE ordered value versus billed value. I have had this kind of usecases in the past.
https://dax.guide/userelationship/
I am not sure I know how to apply this. There is only one $ value column, this is a year over year calculation. But there are two dates (create and billing). I want to see the value in the billing date, but I also want to be able to drill into a single year from the order create date. The sameperiodlastyear isn't working, I think because 2 dates are involved.