Please read link and update your title to be more descriptive of your actual question and explain it in the body of the post.
This will allow search engine to find your question and help future users to benefit from solution provided...
Too generic of question and your sample is of no help.
At any rate, in PowerBI you'll only have commenting function only at visual and report level. Not at data level.
For that, you'll need some sort of 3rd party service/plug-in.
@Rameez Sarang
Your issue is that you are asking DAX/Data model related question. Yet, your file only contains flat list. With no data model or schema.
DAX is highly contextual in it's nature and will evaluate differently based on context it's evaluated on.
Without knowing your data model...
Use TRIM. It won't alter stored value. It's just used in CF, to check if extra spaces are causing otherwise same text to be mismatch.
If you just use =A2<>A3. Then it will mark every cell that is different between row2 & 3. Ex: It will mark Married/Single as flag. Which I don't think you want...
Then something like below. But note, it will only capture extra spaces causing difference.
=AND(K2<>K3,TRIM(K2)=TRIM(K3))
But in general, it's far better to apply data clean up to range. Rather than try and identify individual issues.
But you have no model in your sample.
As well, your pricing table should be flattened out.
It is critical in PowerBI and DAX to know your data schema and also how and where you are displaying data.
DAX is evaluated by context of calculation and will return different result depending on this...
So your main issue here is the relationship between the two tables. If you pick NW10 in postcode slicer. That will already filter out calculation result to just the ones that match NW10 partial.
What's your end goal?
No. Power Pivot based on Data model requires data to be stored in cache.
Cached data will stay with the workbook.
Only way to reduce size, would be to look at your data and see if you can reduce footprint.
Data granularity - Do you actually need all the rows in data model. Or can you...
Not sure if your data is really representative of your issue.
Typically speaking this type of calculation requires one of following.
1. Add calculated column, either at Power Query stage or at DAX. Then use the calculated column for down stream calculation.
2. Add table variable to your DAX. To...
Hmm, best bet in your case is to just merge Access level table to IssuedBooks.
Since BookInventryDetail has no employee info.
You'd connect the two using "Book".
You have multiple path from AccessLevel to BookInventryDetail. That is causing ambiguity in data.
How you should model data, will depend on few things...
But read through link to understand importance of appropriate data model in BI (PowerBI, Excel Data model) etc...
I assume you have Calendar table that has all dates of given year.
1. You use CALCULATE(Measure,FILTER(ALL(Table),Year([DateColumn])="2024")) to obtain data from all of calendar date based on condition. You can make "2024" variable in Dax. Alternately you'd use ALLEXCEPT()
2. Simple subtraction...
Hmm, that depends on URL. And if it's interpreted as valid.
For test, I used google image search result and used jpeg base64 string as url. And it worked fine...
You should be able to zip PBIX file to upload. Without looking at sample data, bit hard to pinpoint your issue.
But from what I understand, you probably shouldn't use relationships between the two tables. Just calculate starting coordinate (i.e. address coordinate). Then you need to calculate...
Just another way to remove special characters (especially when exact characters are unknown).
= Table.AddColumn(PreviousStep, "Required Data", each Text.Select([Current Data],{"A".."z", " "}))
Usually requires another step to clean up extra spaces.
In DAX calculated tables are only evaluated upon data load. And not when you make changes to slicer selection.
If you need it to be interactive, you need significantly more complex set up. Or you can just use built-in filters to limit what's shown.
As well, you need to replace ''[Client name]...
Are you doing this in Excel Data Model or is it in PowerBI Data model?
If I recall Excel data model doesn't support calculated tables. I'd recommend doing most of the operation in PowerQuery stage.
If using PowerBI, then you can simply do it like below.
Table 2 =
VAR _temp =
SUMMARIZE (...
You are missing brackets for MIN and MAX.
Dates Range = FORMAT(MIN('Semantic FactCommunications'[LetterSentDate]), "MM/DD/YYYY") & " to " & FORMAT(MAX('Semantic FactCommunications'[LetterSentDate]), "MM/DD/YYYY")