Forum Discussion
Helper IDax command to get the values based on paramter date
Hi Pra2010Gha , Thanks for reaching out to the Microsoft fabric community forum.
I have created a new .PBIX file based on your requirements. Instead of using field parameters, I used a slicer for the date column, as field parameters are not the most suitable option here.
On page 1 of the report, you can use the slicer—set it to 18th Oct to get the desired output, which is 3.5 + 6 = $9.5. On page 2, I added a table with a DAX measure to show the price of the fruits on the transaction date. You can use whichever option works best for you.
Please refer to the attached .pbix file for more details and let me know if you have any further questions.
Thank you.
Community SupportHi Pra2010Gha , Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
Helper ICan some one please add a date parameter to the above pbix file.I tried adding and its not working properlyThanks
- v-hashadapu
Hi Pra2010Gha , Thanks for reaching out to the Microsoft fabric community forum.
I have created a new .PBIX file based on your requirements. Instead of using field parameters, I used a slicer for the date column, as field parameters are not the most suitable option here.
On page 1 of the report, you can use the slicer—set it to 18th Oct to get the desired output, which is 3.5 + 6 = $9.5. On page 2, I added a table with a DAX measure to show the price of the fruits on the transaction date. You can use whichever option works best for you.
Please refer to the attached .pbix file for more details and let me know if you have any further questions.
Thank you.