Forum Discussion
Dynamic Measure as per selection (In my case Date selection)
This is what i have been able to come up with. PBi file attached.
This is what i have been able to come up with. PBi file attached.
Hi Ashish_Mathur ,
The reason for asking below question is Dulpicate date rows between Earliest and Latest date in a table because when I change remove rows where Quantity and Price columns are Zero then I coudn't able to get the expected result as below
Before changing data 👇 :
After removing rows (6 & 9) when Quantity equals to Zero. I am missing value for Material X3 for the month of February 2024 as in excel screen shot below
After removing rows 6 & 9, I am missing Material X3 for the month of February 2024 as below
In my actual data I don't have data when quantity is Zero, so I just wanted to duplicate the values with Zero between earliest and Latest available dates.
By the way, thanks for your response.