Hi have 2 tables: 1. Calendar: has daily dates for 4 years 2. Fact table: Sales of weekly data Relationship is on to many. When I add Date from the calendar table in to a slicer to filter for spe...
Hi I have a requirement wherein I want to count distinct employeeId for the products. For example, from the sample data below, 2nd snap is the sort of required output. If we look at th...
I am using donut chart and it will be displaying numbers in "k" format.
I want the entire whole number instead of "k".
How to do this..?
For example, 2.3K should come as "2320".
0.21K sh...
I have sales fact table that has columns for sales in local currency, Sales in USD, Sales in EUR, Sales in GPB and the local currency code. I have a exchange rate table that reports each currency ex...
Hello Community - Modifying my original post to better explain what I am trying to do. Creating a field measure with these 4 options is easy and of course you end up with...
Is it possible to merge two .pbix files into one so that one dashboard can be built? If both .pbix files use the same data source and one developer works on a page and another works on a second...
I have data from a sharepoint list, and some excels how would i setup automatic refreshes for the data to be updated and not mess up my measure/calculations?
I have data as per below for many companies and I want to create a page filter which will remove any companies that have their total hours less than 100. I have tried using the filters but it doesn't...
Estoy tratando de modificar el subtotal en una matriz, quisiera que en el subtotal de la matriz solo apareciera los datos 2023df y 2023Real sumados, los del 2022 real no los tomara en cuenta, tienen ...