My extract has separate created and resolved date tables in the same data source. How to compare?
Hi all, I am hoping someone can assist me with a comparison issue I'm having with data in Power BI. My extract has both 'Created Date Time' and 'Resolved Date Time' data in the same csv, and both have date tables / hierarchies. I have created measures to calculate the count of both and that works to a point. The issue I'm trying to understand is how to add month and year fields. I think I need a separate date table. I would like to achieve a result similar to the graph below from Excel. Any advice would be greatly appreciated.
Column level slicer interaction on cards
I have a single table, where i have to create a dashboard for data profiling for each column. My requirement is i need a slicer for all the columns from the table. And i have to create 5 to 6 cards the measures are Distinct count, Row count, valid data, error, null, min,max and nameof the column. When i slice the column the above measures should filter the values for that particular column. I tried to do parameters to create slicers but my problem is i am not able t create dax measures that changes when colunm level filter is applied
Column Comparison - Vlookup
I have two columns I need to compare, one column: 'MOM Stocking Report': Shows all stocked items & 'Demand Seg': Shows the complete list of purchased items. I need to compare them against one another to know which ones are stocked and which are not. As you can see the equation below, it appears to get me halfway there as the pie chart does capture the data, however I am not certain this is correct, Also when I click on the 'YES' stocked pie chart, the table shows nothing. Also, technically the 'Agreement Level' should be a 0 if 'Not Stocked' or come back with null. My relationship cardinality is at Many to Many , it wont let me change- I have removed all duplicates from Power Query. So I am basically out of ideas: My Stock or Not Equation: Stocking Agreement? = if(isblank(countx(filter('MOM Stocking Report','MOM Stocking Report'[Item Number]='Demand Seg'[ITEM NUMBER]),'MOM Stocking Report'[Item Number])),"YES","NO")
