How to make a DAX calculation return BLANK rows
I'm working on a Power Bi template for my company. Since we are a global comapny i added Time Zone tables that help the end-user filter the visual for their Time Zone. Now I'm trying to create a DAX measure that will get the values in a DATE/TIME type column and sum the given UTC Offset in Hours, however I'm having a hard time when there's no value in a give row, DAX will just either not return the rows with blank or return the offset. What I'm trying to achieve is a function that will ignore the blank values and still return them, and when there is a value actually SUM the End Time UTC with the Offset. Note: [Current UTC Offset] is a measure that returns a decimal number from -12 to +12 How can i achieve this?
Not show Sum or Average in Total (PIC INCLUDED)
I have a matrix table with two rows. Main one is C1, and the second is C2. I then have C3 for values. I want to display the sum only by C2 as in this situation it doesnt make sense to show C1 totals. Is there a way to omit the numbers in the main category of C1? I have displayed a pic. Any help would be appreciated. So omit the 15 under AAA, BBB, etc. Just clicking row totals doesnt work because I cannot have the end-user click the plus sign and have it roll up to that AAA = 15 ever.
Calculate cumulative total by multiplying value to itself.
Hi. Asking for your help on calculating cumulative total by multiplying the average value to itself. I want to achieve the line chart below. My example is Id 1. For the data model the relationship of date table to Table 1 is inactive because there is another active relationnship in that table. For the sake of simplicity I just shown how End Date is connected to the date table as well as Start date from another table to the date table. Thank you in advance for your help.
How to show latest date as default selection in a slicer.
Hi Team, Please help me out with this query. How to show latest date as default selection in a slicer. For Example, we have a date column contains date from 01-10-2022 to 22-12-2023. So, when i drag to slicer i need to show defalut selection as 22-12-2023. If user need to select other date he need select. otherwise it should be default. Thanks & Regards, Prasad
