Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Find articles, guides, information and community news

Most Recent
JarroVGIT
Resident Rockstar
Resident Rockstar

Recently, I ran into a case where the customer required a filter on a multivalued column. However, he wanted to be able to slice based on a single value rather than the combinations of values. The solution we implemented was leveraging Power Query rather than DAX and enabled the customer to slice the data based on any occurrence in the multivalued column. This approach also makes it possible to filter in multiple columns using a single slicer!

Read more...

amitchandak
Super User
Super User

Power BI Time Intelligence functions provide a powerful way to get different types of time periods and time comparisons. Some of these are MTD, PMTD, PYMTD, MOM, MOYM, QTD, LQTD, QOQ, YTD, LYTD YOY etc. But dealing with a non-standard period can be a bit difficult, especially when months are not the standard months. In this article, we try to take on a case of non-standard periods (months).

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.