Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ,
Kinldy help me on this query.
I am trying to get the all rows which under date range. I am using the below query it not shoing any result.
Thanks,
Santhsoh
Hi @santhoshacc,
If you put the date column in the slicer, you can create a measure simply like below:
Best Regards,
Qiuyun Yu
Hi ,
Thank you !
But i am takeing the value of the all , year ,month,day from slicer (means 3 slicers: 1.yearvalue 2. month value , 3.day value.
i need send to these three value as date ,then i will get the result by using date.
Thanks,
Santhosh.
Hi @santhoshacc,
Not sure what you mean. The measure provided before can work with three slicers. Please see attached pbix.
Please share your sample pbix file and tell us your desired output.
Best Regards,
Qiuyun Yu
Hi,
Please help on the below query.
I am taking the value from slicer and passed into query. But is not working for me ,it says like conversion error (data converion).
Comparing the sliver value with Date filed in date table.
Thanks,
Santhosh.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |